Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey all,
Just doing a pretty simple filter on a Date column. Trying to filter the data to be "is in year" "This Year" or "is in year" "Last Year".
After setting that up, the query just keeps going and never finishes. Or at least it still hasn't finished yet.
Anyone else have similar issues? - thanks!
EDIT:
Found a solution, just first go to Custom Filter instead of Year. For whatever erason if you go to Year first and choose This Year and add a second condition for Last Year the query never ends.
Solved! Go to Solution.
I checked this out in the Query Editor, as we don't have the dynamic Last Year / This Year options in the other windows. I couldn't reproduce the same issue, and the workaround still works if anyone else runs into this.
I checked this out in the Query Editor, as we don't have the dynamic Last Year / This Year options in the other windows. I couldn't reproduce the same issue, and the workaround still works if anyone else runs into this.
Are you doing this filter in the Queries window?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |