Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

YoY change in matrix table when there is data missing for certain months

Hello,   I have financial data for several locations for both 2018 and 2019, there are certain locations that have missing data for certain months. I've created a few measures that combined show Yo...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

ISINSCOPE should help you in your scenario.

Measure = IF(ISINSCOPE(Dimdate[Date].[Month]),[PY],BLANK())

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the reply! This seems to just produce a blank value for the aggregate? I'm trying to get the correct aggregate to display -- that is one that takes into account only months that have data for both years.

 

 

Thanks again, and let me know if you have any ideas