The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Power BI – How do you create the expression to create the difference between two columns?

Power BI – How do you create the expression to create the difference between two columns?

0
Votes
1
Answer

If I wanted to subtract my UnitPriceDiscountPct from my UnitPrice to create a GrossSales Column can someone write the measure expression I would use?  

Nevermind I added a column in the data field. But is that what you are supposed to do? Or should you create a measure without creating an excel like field in the data. I think there are pros and cons, but I cannot organize this is my mind yet. If anyone has any clarity, I would appreciate it.

6 months
1 Answer

365 Team
0
Votes

Hey Christina,
I would suggest using a Measure instead of generating an additional column to do this aggregation for you. Remember, measures take less resources to process, they are only executed once they are called which improves the overall dashboard performance.

Thanks, I understand what you mean now!

6 months