This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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:
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
Solved! Go to 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
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 38 | |
| 29 | |
| 28 | |
| 20 | |
| 18 |
| User | Count |
|---|---|
| 66 | |
| 36 | |
| 30 | |
| 25 | |
| 24 |