Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

month year

Hello Expert,

i have used funciton for creating month year calculation but how to add this into hirarchy to get unique results

Format('Table 3'[Date],"MMM-YY")

Shree

Anonymous
6 years ago
It seems Youa re formating as Text. so Power BI will not detect this as Date to display as Hierarchy.
Format('Table 3'[Date],"MMM-YY")

Add another column
Test1 = DATES[Date] then Set DataType as Date/Time
Format: March 2001 (MMMM yyyy)

You might find this below link useful.
https://community.powerbi.com/t5/Power-Query/Date-Display-Formats/td-p/2145

5 Replies

parry2k
Super User
6 years ago
Anonymous can you explain bit more what you mean by adding to hierarchy?
- Anonymous
  Not applicable
  6 years ago
  this is calendar table script
  Table2 = CALENDAR(DATE(2016,1,1),DATE(2019,12,31))
  from which i am able to get readily avl hirerarchy but how to add newly created above column into that so that i will get month and year also hirerarchy
  
  shree
  - Anonymous
    Not applicable
    6 years ago
    Hello Expert,
    1st step to create calendar using below mentioned scripts . which will give hirachy also
    Table2 = CALENDAR(DATE(2016,1,1),DATE(2019,12,31))
    2nd step create a column
    Format('Table 3'[Date],"MMM-YY")
    and add month- year column in hirarchy or tell me the alternate step where we can add month-year column in hirarchy
    
    Shree

Related content