Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Date column marked as datetable does not shows Year-Qtr-month- day Hierarchy.

I am new to Power bi. Need help.

I have created table name Calender as

Calender = CALENDARAUTO()

Month = FORMAT(Calender[Date],"mmmm")

Month Number = MONTH(Calender[Date])

Quarter = FORMAT(Calender[Date],"\QQ")

Year = FORMAT(Calender[Date],"yyyy")

Selected date column as Date table.As relationship is made with original data table.

it shows like this.

Periyava123_0-1652960843982.png

In canvas also it is showing 

Periyava123_1-1652960902862.png

How can I get Year,Month, Qtr and day Hierarchy?

 

 

Status: New