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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.