Forum Discussion
Solved
YTD with month filter using Direct Query
Hi All, I am trying to create YTD sales at category level with Month filter using power bi direct query. If we select month filter value"March" the expected result should be the YTD sum till...
Hi Anil
Can you please try using ALLEXCEPT instead of ALL since you are looking to see the data at the category level.
https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax
Best regards.
Hi Anil
Can you please try using ALLEXCEPT instead of ALL since you are looking to see the data at the category level.
https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax
Best regards.
Anonymous
Thanks for the reply.
Previously I used allexcpet(), but it was not working. Now I tried again, able to see the expected result.
Cool, thanks for confirming.
Please mark my answer as accepted solution, will help others as well. :)
