Forum Discussion
Helper I% Difference from the previous quarter
Community Championout of interest why is your report not linked directly to your date table?
Helper IHi vanessafvg , The 'period' column in the Report able is a date data type. I wanted to extract the financial year, financial quarter and financial month, so I created another table in Power BI called Calendar. I think directly linked the 'period' data column to the date in the calendar table.
- vanessafvg
the problem is (and its difficult to tell without access to your model) but to me it looks like its going via the target table, it should be directly linked, your report table should be directly linked to date in a one to many relationship to your calendar
ie active relationship one to many from calendar to report, I can't see the relationship in your model pic above.
otherwise please supply your model so one can see what is going on.
- daniellamoore29
vanessafvg this is my full data model. The targetID is connected to the Report table, so the calendar target and report tables should all be linked no?
- vanessafvg
This is actually difficult to help you with such limited information.
What is the meaning of linking target to report? I will need to understand the business objective of what you are trying to do here.
The issue here and the error you are getting is that it is unable to return a single value for your measure which means your relationships between your tables are returning multiple rows rather than just one value, which in the case of a measure, it requires one value.
This problem almost always lies in how the data is modelled.
You will need to explain what you are actually trying to do, i think more business context is required here.
I personally would never link it that way;
calendar should be connect to report separately
calendar should be connected to target separately
but without understanding what you are trying to measure, and why target sits in the middle the technical only information only you have provided isn't enough to help you solve this problem.
hope that makes sense.