Forum Discussion
Conveting excel formula into DAX
Hi, I have a following excel formula and I have to convert that into DAX query. need solution =SUMIFS('Raw Data'!$F:$F,' Raw Data'!$A:$A,$A$4,'Raw Data'!$E:$E,$B6,' Raw Data'!$B:$B,$A6,' Raw Data'!...
ValtteriN
Community Champion
Community ChampionHi,
You can convert this into DAX by using CALCULATE + SUM.
Example:
Here we are calculating SUM IF cakes = T1 or T2
Cake Total = CALCULATE(SUM(Cakes[Sums]),'Cakes'[Cakes]="T1" || 'Cakes'[Cakes]="T2")
End result is 500 as expected.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
I just need explanation for the excel expression?
What does excel expression represents?