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.
Hi kevbrown1980
Can you please try the below ?
Make sure it works when a relationship exists between the two tables.
Total Amount :=
SUMX (
Table2,
IF (
RELATED ( Table1[Level 5 Expense Description] ) = "Contract Income - Fixed",
Table2[Budget - YTD],
Table2[Actual - YTD]
)
)
If this answers your questions, kindly accept it as a solution and give kudos.
Sadly it doesn't like that