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.
Hi,
I am trying to calculate YTD by using TOTALYTD and the quick measure approach, but none of them seem to work. I have data with both actual data and forecasted data. The date table ranges from 2017 to 2019. When I try to calculate YTD I get the sum of revenue for the last year in the data set.
How can I get the YTD revenue for 2018 (01.01.2018-01.03.2018)?
Hi @mike87,
Please create a calendar table and link it to your model and then create your measure either with TOTALYTD or calculate with DATEYTD.
If it is not clear please share dummy data and I will make a try.
Ninter
Thank you for your response @Interkoubess. The data I have presented is dummy data. The actual data has a calender table as well, but still the same issue.
I'm happy to share the data with you, but I don't know how to :S
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |