Forum Discussion
Solved
sumif not working
Hello - I would like to add in a sumifs type of formula in Table B. I would like to add in sales by total client and by date from Table A in Table B. What is the formula I can use for that? ...
Hi homboy27 ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!
Try using below DAX:SalesByClientAndDate =
CALCULATE(
SUM(TableA[SalesAmount]), -- Replace with the actual column
TableA[Client] = TableB[Client],
TableA[Date] = TableB[Date]
)
Please refer the solved links below:
Solved: Sumifs in power bi - Microsoft Fabric Community
Solved: Power BI formule Sumifs - Microsoft Fabric Community
Hope this helps.If so, consider accept it as solution.
