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.
I have a column for invoiced_date that was already transformed to a date type in power query, but is not showing that it is a date column and because of that it isn't modeling correctly? What could cause this? Other date columns in the same table are operating correctly.
Hi, @vonw13 ;
Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @vonw13 ;
It should be because your column is related to other tables, and it is the "many" end of the relationship, so it is not displayed. This is a normal phenomenon, caused by design.
When the relationship is one-to-many, Power BI will respect your decision and remove the "many" side date hierarchy.
When the relationship is one-to-one or one-to-many, Power BI will determine which one is truly "many" side according to the order of selection.
https://community.powerbi.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@vonw13
Please check in Power query if the INVOICE_DATE column has errors. With out enough details, it's hard to suggest a solution.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
No errors and no blanks, what other details would be helpful?
@vonw13
A PBIX with sample data showing the date issue will do
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The total in measure 2 is correct when using the invoiced date within the same table, but doesn't do mtd when using the calendar table.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |