Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Solved! Go to Solution.
Hi @Anonymous
When you mark the table as date table,you lose Power BI's built-in date hierarchy.To get it back you would have to un-Mark as Date Table.The other way is creating the hierarchy manually.Add Year,Quart...columns first.Then 'New hierarchy' for date column.Then add Year,Quart...columns to the hierarchy.
Quarter = "Qtr" & INT ( FORMAT ( [Date], "q" ) )
Regards,
Hi @Anonymous
When you mark the table as date table,you lose Power BI's built-in date hierarchy.To get it back you would have to un-Mark as Date Table.The other way is creating the hierarchy manually.Add Year,Quart...columns first.Then 'New hierarchy' for date column.Then add Year,Quart...columns to the hierarchy.
Quarter = "Qtr" & INT ( FORMAT ( [Date], "q" ) )
Regards,
Hi,
For Month and Year, you can write the following calculated column formulas
Year = Year(Calendar[Date])
Month = FORMAT(Calendar[Date],"mmmm")
Hope this helps.
User | Count |
---|---|
134 | |
74 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |