Forum Discussion

jnguyen21's avatar
jnguyen21
Icon for Helper I rankHelper I
4 years ago
Solved

Matrix Total is Not Correct - Specific Date

I'm putting together data that shows actuals up to a given month, and the rest of the year budget. The issue I am having is the total is not adding up correctly for the Budget ROY Column. The logic i...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jnguyen21 , Based on the row/group by of you visual, change like

 

Budget ROY =
var first_day = min('Calendar'[FirstDayofYear])
var last_day = max('Calendar'[LastDayOfPeriod])
return
Sumx(values('Calendar'[Fiscal Period]) , IF(SELECTEDVALUE('Calendar'[LastDayOfPeriod]) )>= first_day && SELECTEDVALUE('Calendar'[LastDayOfPeriod]) <=last_day,[Budget],0) )