Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

Make sure that the “Created” field is not related to a date in another table; if it is, there is no hierarchy of dates on multiple ends.

 

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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.