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.
Can you please tell us which dates should be the minimum date and maximum date for the current 12 month period that you want? For example, today is 2022/9/28, so your expected current period should be 2021/9/28 ~ 2022/9/27, or 2021/9/1 ~ 2022/8/31 (12 full calendar months)? Or some other date period?
Best Regards,
Community Support Team _ Jing
There is a DAX function "SAMEPERIODLASTYEAR". Try that one to get last year data.
Thank you.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |