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.
Hello friends,
We try to create a simple measure that compares revenues from previous month.
Our data source is Kusto (Azure Data Explorer).
It seems that the simple CALCULATE(SUM(Amount),DATEADD(Calendar[Date],-1,MONTH)) is not working well
I am aware that working with Direct Queries is not always possible to do many DAX calculations, but this is very simple need - compare with previous period
Any ideas?
Thanks
Michael
Hey,
this article explains a lot of date related calculations: https://www.daxpatterns.com/time-patterns/
I assume that you will find a solution for your problem.
Regards,
Tom
Thank you, Tom
But my question was about the context of Kusto (Azure Data Explorer)...
Which calculations are working with Direct Query?
Thanks
Michael
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |