I have a table in my data model which I have a linked table back into Excel (via Data > Existing Connections > Tables > myTable). However, I only want rows of my table where a certain column equals a specific value (saving me from bringing back about 75% of the table that I don't need).
I see that if I right-click the query table there is an Edit DAX option, which I'm wondering if I can use to apply a filter.
How would I write that DAX statement or is there any other easier way? I want the data returned as a table, not as a PivotTable.
Thanks
I see that if I right-click the query table there is an Edit DAX option, which I'm wondering if I can use to apply a filter.
How would I write that DAX statement or is there any other easier way? I want the data returned as a table, not as a PivotTable.
Thanks