Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Need Date Hierarchy

I copied a table from a power Bi Report that had a YEARMonth Date Hierarchy.  When I placed table into my other Power Bi Report, I no longer see the Calendar Icon next to YEARMonth or the Date Hiera...
Need Help
  • bdehning's avatar
    bdehning
    2 years ago

    I did not realilze I had turned off Auto date/time under Time Intelligence.  I turned it back on and I see Date Hierarchy.  

lucadelicio's avatar
lucadelicio
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hi,
you need to create a column date type from the text YYYYMM.
So you can use the DATE(<year>, <month>, <day>) dax function.
You can try something like this:
DateType =
DATE(LEFT(YYYYMM, 4), RIGHT(YYYYMM, 2), "01")
Then set this column as Date type.

Pay attention to type during the conversion.
Mark as solution my reply if i help you.
Thank you.