Date Column Does not show hierarchy

Anonymous · ‎05-27-2020

Hi Team,

I have two columns here, both were String from the source and I have transformed them to date, they look like this.

Now when I come to the report side, I see the columns like this.

I don't understand the issue, but any calculation with using "planned date" gives correct value, and using "actual date" gives the wrong value.

mwegener · ‎05-27-2020

Hi @Anonymous ,

Is "planned date" related to a date table?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast

Anonymous · ‎05-27-2020

Hi @mwegener , No, both the dates are coming from Source SQL data.

mwegener · ‎05-27-2020

Hi @Anonymous ,

can you share a screenshot of the data model view?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast

Helpful resources