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.
For a date calculation, which is driven by two independent date tables, I need a dynamic Current Quarter-Year Table and a corresponding (dynamic) Previous Quarter-Year Table.
The Current Quarter-Year Table is simply:
Hi:
You can add these calculated columns into your table(s):
@acg ,
Hope you need flag only
Switch(True() ,
[year_quarter] = Format(today(), "\QQ YYYY") , "This QTR",
[year_quarter] = Format(eomonth(today(),-3), "\QQ YYYY") , "Last QTR",
[year_quarter] )
I really need a table in order to make the 30 odd other measues in the dashboard working that use that above table.
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 |
---|---|
44 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |