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,
Can anyone help me with tips or logic how to show up my Last 1 Year Ago, Last 2 Year Ago, and Forecast in the red square that not show up?
Dax that I used:
Year
Assuming your Calender table is a true Dates table (contiguous, covering, marked as Dates table) you can use standard Time Intelligence functions like SAMEPERIODLASTYEAR or DATEADD. That should make your code a bit more concise.
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |