Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've checked similar topic, but couldn't do the same for my case. Please help.
Solved! Go to Solution.
@YeldarR , Try like
Return actual balance =
VAR maxDate = MAXX(allselected('BS_actuals') , 'BS_actuals'[date_key])
RETURN
SUMX(FILTER(BS_actuals,[date_key]=maxDate),[value])
or
Return actual balance =
VAR maxDate = MAXX(allselected('BS_actuals') , 'BS_actuals'[date_key])
RETURN
SUMX(values(BS_actuals[Level1]), calculate( MAXX(FILTER(BS_actuals,[date_key]=maxDate),[value]) ) )
@YeldarR , Try like
Return actual balance =
VAR maxDate = MAXX(allselected('BS_actuals') , 'BS_actuals'[date_key])
RETURN
MAXX(FILTER(BS_actuals,[date_key]=maxDate),[value])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you. Nope doesn't work. It works only for level1 layout, but level2 layout show maxx instead of sum.
BS actuals goes the following:
BS layout:
@YeldarR , Try like
Return actual balance =
VAR maxDate = MAXX(allselected('BS_actuals') , 'BS_actuals'[date_key])
RETURN
SUMX(FILTER(BS_actuals,[date_key]=maxDate),[value])
or
Return actual balance =
VAR maxDate = MAXX(allselected('BS_actuals') , 'BS_actuals'[date_key])
RETURN
SUMX(values(BS_actuals[Level1]), calculate( MAXX(FILTER(BS_actuals,[date_key]=maxDate),[value]) ) )
Thank you!
First one is correct.
Everyone who complies balance sheet, must use this command to get balances correct:
Return actual balance =
VAR maxDate = MAXX(allselected('BS_actuals') , 'BS_actuals'[date_key])
RETURN
SUMX(FILTER(BS_actuals,[date_key]=maxDate),[value])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |