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 longer get data for the current period, the first two columns.
And then when I select the year 2023 I don't get any data at all. Any ideas on what is causing this to happen?
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.
Please provide more info. It won't be solved by looking at those pictures.
What's your data? What are the relationships? What is in the visual (measures? columns?). What's in the slicer?
What are you expecting to see?
The first 2 columns of data are simply a sum of applications received and policies received.
Applications = IF( SUM('Cognos Data'[Applications]) =BLANK(),0,SUM('Cognos Data'[Applications]))
Policy Count = IF(SUM('Cognos Data'[Policies])=BLANK(),0,SUM('Cognos Data'[Policies]))
The third and forth columns are the same sum of applications and sum of policies for the prior year.
Prior Year App Count = IF(CALCULATE([Applications],SAMEPERIODLASTYEAR('Calendar'[Entry Date]))=BLANK(),0,CALCULATE([Applications],SAMEPERIODLASTYEAR('Calendar'[Entry Date])))
Prior Year Policy Count = IF(CALCULATE([Policy Count],SAMEPERIODLASTYEAR('Calendar'[Entry Date]))=BLANK(),0,CALCULATE([Policy Count],SAMEPERIODLASTYEAR('Calendar'[Entry Date])))
The slicer is simply pulling the Year field from my calendar table.
Calendar = CALENDAR(DATE(2020,01,01),DATE(2025,12,31))
The calendar table is connected to the Cognos data with this relationship.
I hope this is enough information to assist me. I don't know where to look to resolve this. Thank you!
