Date Relationship not working

[Lodan]

Hello,

I am scratching my head here and I know its got to be an obvious answer so apologies in advance.

SD Example.pbix

I have 3 tables:

• Dates table
• Orders
• Items

The revenue is in Items but the dates are in Orders.  So I have a relationship in PON netween the two and between Orders and Date.

I have checked formats etc and even tred shifting the dates to Items via a lookupvalue to Orders but nothing has worked.

My MY is always blank even though it should be Jan 2024.

Any help would be appreciated please.

Thanks and regards

[FBergamaschi · Accepted solution]

your dates table contains date from may 2024 to july 25

your roder table contains dates only in jan 24

so there is no match

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Lodan]

Oh darn!

Thank you for daving this idiot!

[FBergamaschi]

welcome

nobody is perfect, thanks for joining the community