Forum Discussion

CJ_96601's avatar
CJ_96601
Helper V
4 years ago

YE data

Need help to get a constant YE data that is not affected by Filter:

 

Measure = (CountYE + Counttodate)/2

 

Based on below table, countYE for 2021 must be 24  even if i select year 2022 month Aug. 

 - countYE for 2021 must be 24  even if i select year 2022 month Jan and so on and so forth. 

 

his is without using edit interaction. 

 

Example: 

 

YearMonthCount
2021Jan2
2021Feb2
2021Mar2
2021Apr2
2021May2
2021Jun2
2021Jul2
2021Aug2
2021Sep2
2021Oct2
2021Nov2
2021Dec2
2022Jan5
2022Feb5
2022Mar5
2022Apr5
2022May5
2022Jun5
2022Jul5
2022Aug5

 

 

Thanks