Forum Discussion

Austinehype's avatar
Austinehype
Icon for Helper I rankHelper I
5 years ago

Sum the remaining months

Hi, I have the below table where I would like to have a measure that is sum the remaining month number. The FY is starting at 2020.04 and end at 2021.03 The MTH left shows the remains number of mo...
Need Help
Austinehype's avatar
Austinehype
Icon for Helper I rankHelper I
5 years ago

Hi Anonymous 

 

Thank your for your help, I tried the above measures and it seems like it's sum up every single rows.

Austinehype's avatar
Austinehype
Icon for Helper I rankHelper I
5 years ago

I have 81744 rows and the column mth left 12 distinct values