Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I used the DAX formula to accumulate sales for the last three months but I complete the figures for the next 2 months and do not want to see them. I tried Filter but I can't get him to delete me for the next few months (the 6th and 7th)
The formula I use is
Hi,
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
@Anonymous , Try adding a filter like
_MEDIA MOBILE TRIMESTRE - CALCULATE('_TB MEASURES'[_TOTAL SALE Current Year],
DATESINPERIOD('MY CALENDAR'[Date],
LASTDATE('MY CALENDAR'[Date]),-3,MONTH) , 'MY CALENDAR'[Date] <=eomonth(today(),-2)+1)
eomonth(today(),-2)
-2 can be -3 or -1 depend on need
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |