🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
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?

Back to all questions

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

10 months ago
Vote Up Vote Down
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.

– 10 months
1 Answer

365 Team 10 months ago
Vote Up Vote Down
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!

– 10 months
You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #.