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.
Good morning
I'm trying to apply a date filter relative to a visual in which I just show the data for the full current month and the full 12 months next, I have created calculated columns in the calendar table
I did not get it completely. this should give this + 12 months
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],startof month(Sales[Sales Date]),13,MONTH))
Use date calendar
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/
Hello again and thanks for the answer, I do not get the visual show me only the current month from start and the next 12 months complete with the measure applied, shows me dates that I would not want to see. My apologies since I have asked it incorrectly, perhaps attaching a screen knows how to explain it better?
Thanks a lot
PS: Explaining it another way: If relative date filters offered me from the beginning of the current month onwards and not from the current date or from the next month my problem would be solved.
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |