Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone, how can I do this formula cleary simple in Excel but in DAX? I'm struggling to get it.
=T3/SUMIFS(T:T,AM:AM,AM3)
Solved! Go to Solution.
SumIF = //try this
DIVIDE(
Table1[T3],
CALCULATE(
SUM(Table1[T]),
FILTER(
Table1,
Table1[AM] = EARLIER(Table1[AM])
)
)
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
SumIF = //try this
DIVIDE(
Table1[T3],
CALCULATE(
SUM(Table1[T]),
FILTER(
Table1,
Table1[AM] = EARLIER(Table1[AM])
)
)
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!