Forum Discussion
Solved
SumIf
Hi I'm looking to convert a Qlikview Dashboard into PowerBI, not my easiest project. I have a calculation which is Sum(if in Qlikview but I'm not sure how to recreate it in PowerBI. Can some...
Hi kevbrown1980 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out and consider sharing a sample PBIX file or a small sample dataset so that we can reproduce the issue from our end and guide more accurately.
Thank you.
kevbrown1980 Try using
DAX
Measure =
SUMX(
YourTableName,
IF(
YourTableName[Level 5 Expense Description] = "Contract Income - Fixed",
YourTableName[Budget - YTD],
YourTableName[Actual - YTD]
)
)
It looks as though this won't work as I'm working from 2 different table. [Level 5 Expense Description] from one table and [Budget - YTD] and [Actual - YTD] from another