Forum Discussion
Missing data
Hi All, I have a problem and cannot figure out why this is happening. When I select the year 2021 the data are correctly populated for all 4 columns. When I select the year 2022 I no l...
I suggest testing in a separate table visual with the column that isn't shown on the above pictures (the column on the far left) and a simple measure, SUM('Cognos Data'[Applications]) with the date field (from Cognos) that is in the relationship. See if you get data for the year 2022.
Add in the Year from the calendar table, see if the data still shows.
If not, examine the relationship and see where it's not working.