Making a date to behave like a date

[Anonymous]

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

[v-frfei-msft · Accepted solution]

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]

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

[Anonymous]

Have you tried formatting it in Power Query Editor?

[Anonymous]

Yes, and still have the same problem