Import filter doesn't recognize blanks My issue is I have a SQL table I'm importing into PowerPivot. All the data appears correctly. But when I apply a filter to the imported field "ABC" such as "not like X" it shows every row that has text that isn't "X".
BUT I need it to also show the b...
Beginners question I am new to powerpivot and asking if someone can explain in laymans terms the following:
I created a relationship lookup Table1-Property = Table 2-Property
Why does the result set below list 2 addresses for each record in Table 1, instead of only one...
Number of servers in a period Hi,
I have a inventory table which has the following fields-
Server Name, Comission Date, Decommision Date
I have a standard date table with regular columns and specific column called End of Month which has the end of month for every date in the date...