Forum Discussion
Helper I% Difference from the previous quarter
Community Championout of interest why is your report not linked directly to your date table?
daniellamoore29Hi 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?