Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Cumulative values in %

Hello
i wrote some dax query but i'm not getting the right result, can someone help me to take a look at my query please?
here is my query

cumul_test = var _Female = F_Rtr[%Female]
var _JoinersFemale = F_Joiners[% Female Hired]
var _mnt = SELECTEDVALUE(D_Calendar[Month])
var _cal =  _Female +_JoinersFemale

var _cumul_1 =CALCULATE(_JoinersFemale,DATEADD(D_Calendar[Month],+1,MONTH))

var _test_test = _cumul_1 +_cal

RETURN
_test_test


can someone help me to write the correct syntax please. what i'm expected to have as result is for exemple

 

for sept 2020

%Female = 20
_JoinersFemale = 5

_cumul = 25

for Oct 2020

_Cumul + octobre values of _JoinersFemale for exemple 10

so _cumul for Octobre should be 25 + 10 = 35% Capture d’écran 2021-01-11 200707.png

 




1 ACCEPTED SOLUTION

@Anonymous , This should be a date, not a month. other options use allselected in place of all

 

var _cumul = CALCULATE(_RosterFemale + _FJoinersFemale - _FLeavers,FILTER(allselected (D_Calendar[Month]),
D_Calendar[Date] <= MAX(D_Calendar[Date])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

hello
i made this table Capture d’écran 2021-01-12 120516.png

using the precedent formula i'm not getting the right result here is how is calculated for exemple the first ligne
sept the cumul is 29,12%

in oct we should have 29,12 - 2,26%(F leavers) +2,8(F hired)
here is the formula

cumul = var _RosterFemale = F_r[%Female_1]
var _FJoinersFemale = F_Joiners[% Female Hired]
var _FLeavers = F_Leavers[%Female_Levers]

var _cumulF = _RosterFemale + _FJoinersFemale - _FLeavers

var _cumul = CALCULATE(_RosterFemale + _FJoinersFemale - _FLeavers,FILTER(ALL(D_Calendar[Month]),
D_Calendar[Month] <= MAX(D_Calendar[Month])))

Return


@Anonymous , This should be a date, not a month. other options use allselected in place of all

 

var _cumul = CALCULATE(_RosterFemale + _FJoinersFemale - _FLeavers,FILTER(allselected (D_Calendar[Month]),
D_Calendar[Date] <= MAX(D_Calendar[Date])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
amitchandak
Super User
Super User

@Anonymous , the expected output is not clear. But cumulative is like

 

CALCULATE(_JoinersFemale,Filter(all(Date), Date[Date] <= MAX(Date[Date])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.