Forum Discussion
Issue with date format/date hierarchy
I have a table with 2 date fields, looking at the properties they should be the same: But they seem to behave differently when I'm trying to filter on a date slider and looking at te ta...
What do you mean by "“Created” field is not related to a date in another table" in fact the whole table is created based on another table (just a distinct subset of fields) and the expired is a calculated column in the original table.
I had a look at the various steps and I can't see any errors (no blank records and the fields are always set to date/time through the various trasformation). Could it be the issue?
TIA
Hi Anonymous ,
That's why, you need to mark it as date table.
Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.