Forum Discussion
Need Help with Creating/Adding a calculated field/column and displaying
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
Hi Anonymous ，
What's your expected results? Could you please provide some samples? If the following screenshot is what you want to achieve?
Best Regards
Rena
Hello Anonymous,
Thanks in advance for the help!
I would love to have a view like the one you have below, but I would also want to look at the variance ($ and %) for the full year by account ( so all my Periods aggregated) and also the variance ($ and %) by Period and by Account.
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?
I really appreciate the help!
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
Thank you Anonymous, this was incredibly helpful!