Forum Discussion
Date Relationship not working
Hello,
I am scratching my head here and I know its got to be an obvious answer so apologies in advance.
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
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
3 Replies
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
Oh darn!
Thank you for daving this idiot!
welcome
nobody is perfect, thanks for joining the community
