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.