Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ))