Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I need Dax formula for last six month(2020-Apr,2020-Mar,2020-Feb,2020-Jan,2019-Dec,2019-Nov)
this month onward 6 month(not 180 days its today to last 6 month)
I need this month to last 6 month
Thanks
Shanvitha
Solved! Go to Solution.
Hi @Anonymous ,
You can refer to this thread:https://community.powerbi.com/t5/Desktop/Help-on-dynamic-axis-based-on-slicer-value/m-p/838336
You can also use "relative date" filter on date.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can refer to this thread:https://community.powerbi.com/t5/Desktop/Help-on-dynamic-axis-based-on-slicer-value/m-p/838336
You can also use "relative date" filter on date.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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...
@Anonymous
Better to use with date calendar
Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-6,MONTH))
Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-6,MONTH))
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/
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |