Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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%
Solved! Go to 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])))
hello
i made this table
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
@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])))
@Anonymous , the expected output is not clear. But cumulative is like
CALCULATE(_JoinersFemale,Filter(all(Date), Date[Date] <= MAX(Date[Date])))
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |