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.
Hi All,
Can some help me with below DAX, I am not able to see results as expected. Attached screenshot for your reference
Thanks
K Raghavender Rao
Solved! Go to Solution.
Are you looking for a cumulative total every month, like
calculate (
SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= max('Date'[date])),[Category] = "Furniture" )
calculate (
SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= date(2020,08,31)),[Category] = "Furniture" )
Make sure you have a calendar table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Are you looking for a cumulative total every month, like
calculate (
SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= max('Date'[date])),[Category] = "Furniture" )
calculate (
SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= date(2020,08,31)),[Category] = "Furniture" )
Make sure you have a calendar table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Very difficult without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, EOMONTH may be of use. Also, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
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 |