Forum Discussion

Raimonds_R's avatar
Raimonds_R
New Member
4 years ago

Totals

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! 🙂

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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])

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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!