Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I am working on a measure that calculates reservation charges from the current YTD compared to the YTD same day last year. I want to see amount booked as of this time last year. The time intelligience functions I have seen seem to lump values together. For example, I only want to compare 1/1/2021 through 7/21/2021 with 1/1/2022 through 7/21/2022. I was thinking something like this but currently this measure is not working:
Solved! Go to Solution.
The following 3 measures can achieve this.
Hope this is helpful to you.
Regards,
Nathan
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |