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,
I have the following excel file which describes the calendar used for my analysis:
I just have the Fiscal Year 19 so no other Years are taken in consideration. First day of the year 27th May, Sunday. We follow a 454 calendar.
I need to build Quarter to date, Season to date and Year to date measures. Can someone please help me out?
I've been trying with some other posts on the forum but actually nothing was helping or working for me.
Thank you so much!!
Sara
@smic11,
Please share sample data of your table following the guide in this thread and post expected result here.
When you calculate year to date measure, you can use DAX below.
YearToDate=TOTALYTD(SUM(table[column]),DATE[Date],"year_end_date")
Regards,
Lydia
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |