Totals

[Raimonds_R]

Hi!

Please help to beginer at Power BI.

How I could create totals for such situation :

I have a budget and actual for every month with monthly filter.

How I could create total for budget and actual in a separate column? With formatting, I found that total counts in 1 column where is Budget+Actual.

If it calculate field, where I could create that syntax and what I should type? Not really familiar with DAX.

Thank for your help in advance! 🙂

[v-kelly-msft]

Hi @Raimonds_R ，

Could you pls add more details about your senario?Such as some screenshots ,sample data and expected output?

Remember to remove any confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[amitchandak]

@Raimonds_R , Nor very clear. If these are columns then you can create a new column

total = [Budget]+[Actual]

If these are from different measure 

Total = sum(Table1[Budget]) + Sum(Table2[Actual])