Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi PBI Community,
I am stumped on this one, so would appreciate any and all tips! I was successfully able to create a YTD measure and it works without overlaying any sort of date filter, relative date filter, etc.
Would you please clarify what do you mean by "month to date" if there is no date to calculate based on it?
Update - I tried using the date field in my fact table with TOTALMTD and it worked, so I just need to figure out why YTD works with my Calendar table, but not MTD and QTD. If anyone has any guidance, I'd be very appreciative - otherwise, I was able to achieve the needed calculation by bypassing my Calendar table. Thanks all!
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
85 | |
52 | |
37 | |
23 |