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.
Hi,
I want to build a formula with sumif functionality in excel, so that sum is calculated for $ amounts for all the transactions whose period value is less than or equal to the value returned by the slicer.
For example:
sumif(Actuals!A1:T1,"<="&D4,Actuals!A6:T6)
A1:T1 = period value (1-12)
D4 = value return by slicer e.g. 9 - (I have included a measure to get the slicer value using the selected value and bringing it in a card)
A6:T6 = $ value to be summed.
Will be greatly appreciated if I can have a similar formula in Power BI?
Thanks
Saad
Hi @Anonymous ,
See if these help
https://community.powerbi.com/t5/Desktop/SUMIF-function/m-p/1131402
https://community.powerbi.com/t5/Desktop/Sumif-based-on-another-table/m-p/520177
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Anonymous , very difficult to guess with formula without data. Have a date table and try like
measure =
var _min = minx(allselected(Date),Date[Date])
return calculate(sum(Table[column]), filter(all(Date),Date[Date]<=_min ))
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 |
---|---|
40 | |
27 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |