Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help with Creating/Adding a calculated field/column and displaying

Hello PowerBI community!   Starting to get my feet wet with PowerBI and want to continue to learn.    I'm struggling to find the easiest/most useful way to created a calculated field/column in Po...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ，

    I created one sample PBIX file based on your needs, you can find the details in this file. Regarding to the second point you mentioned, I am not very clear. Could you please provide an example?

    "Also beyond that, would it be possible to add in calculated rows in the "source column" that would be named "Demand-Acct in $" and "Demand-Acct %" that show the variances in the "value" column?"

     

    Best Regards

    Rena

amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

demand diff = calculate(sum(table[value]),table[source]="Account") - calculate(sum(table[value]),table[source]="Demand")

Ratio = divide(calculate(sum(table[value]),table[source]="Account") ,calculate(sum(table[value]),table[source]="Demand"))

 

For Others please provide sample data and expected output

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the quick response!

     

    So when I enter in your top formula it doesn't subtract the 2 fields... 

     

    I very well may be entering it wrong, but the formula is returning a negative Account number (just changing it to a negative value of the same number), and the Demand number is just the same number in the value column.

     

    Would you know of where I possible could have caused an error?