Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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))
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))
I need the table to be joined also by another variable and adding this date table would create ambiguity between tables.
Have you tried formatting it in Power Query Editor?
Yes, and still have the same problem
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |