Date column not modeling correctly

[vonw13]

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.

  

[v-yalanwu-msft]

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.

[v-yalanwu-msft]

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.

[Fowmy]

@vonw13 

Please check in Power query if the INVOICE_DATE column has errors. With out enough details, it's hard to suggest a solution.  

[vonw13]

No errors and no blanks, what other details would be helpful?

[Fowmy]

@vonw13 

A PBIX with sample data showing the date issue will do

[vonw13]

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.

https://app.powerbi.com/links/9IsH_wdMLb?ctid=83a54211-55a4-49ab-91f2-44a45d244838&pbi_source=linkSh...