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 ，
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!
Anonymous I hate to be a bother, but is there anyway to use those same measures as calculated columns so that I can use them as filters for my graphs?
So I can display the bars and or lines as "Demand - Account" or "Demand vs Account % Variance" by period and in total for the full year?
Sorry for asking another question. Just trying to learn!