Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I'm typing the datediff function, after I enter the first date, a suggestion to use the.[date] function appears. Why does this suggestion appear, does anyone know? Is it needed in a particular case? I don't apply it because it seems redundant to me, but I don't know if I'm missing some kind of good pratice step here.
Thanks for you help.
Solved! Go to Solution.
@Anonymous , When you mark a date table as date, the date you choose will not have that. The date you join with the date of date table might not have the hierarchy too
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
@Anonymous , I usually prefer not to use .date. There many reasons you can lose the default date hierarchy.
I think if you have only date with no time. No need to worry about that. Also in case of timestamp in date, it should give the correct answer
You use this to create new column or use this calculation
date(year([datetime]),month([datetime]),day([datetime]))
Sorry, I did not understand the "There many reasons you can lose the default date hierarchy." part.
@Anonymous , When you mark a date table as date, the date you choose will not have that. The date you join with the date of date table might not have the hierarchy too
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |