Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add a calculated column in a report

Hello,   Power BI noob here, with familiarity with relational databases.   I have a Table style report that lists the beginning balance and YTD activity for specific accounts.  I want to add a co...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

     

    Why don't you use quick measure to sum these two fields.?

     and then include this new measure at the last of your table.

     

     

    Or else you can use this calculated col:

     

    Column=Calculate(sum(table[beginbal])+sum(table[YTD amt]))
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

Just create a measure as below:

Measure = [beginbal] + [YTD amt]

then drag it to table visual.

Result:

 

Best Regards,

Lin