Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Making a date to behave like a date

Hi,

 

I have a date variable that doesnt get the Date Hierarchy and I need it to use Quick Measures.

 

How can I make PBI to understand that this field is a date?

 

 

Thanks in advance,

 

IC

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    We can create a calendar table and make it related to the fact table.

     

    Table 2 = CALENDAR(DATE(2019,01,01),DATE(2019,01,31))

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Have you tried formatting it in Power Query Editor?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes, and still have the same problem

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    We can create a calendar table and make it related to the fact table.

     

    Table 2 = CALENDAR(DATE(2019,01,01),DATE(2019,01,31))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I need the table to be joined also by another variable and adding this date table would create ambiguity between tables.