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...
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!