This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi Guys,
How do I substract a column from another i.e.
| Product | sales 2018 | sales 2019 | substracted |
| x | 1000 | 1200 | 200 |
Thank you
Solved! Go to Solution.
@Glamour16 if this helped you please mark this as "Accept as solution" so that it can help others too:-)
Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Husna
How after substract i can view the total aggregate for column?
substract = Table[Column1]-Table[column2]
Regards,
Manikumar
Proud to be a Super User!
@Glamour16 If you are creating calculated colum then
@Glamour16 if this helped you please mark this as "Accept as solution" so that it can help others too:-)
Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Husna
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 25 | |
| 24 | |
| 15 |
| User | Count |
|---|---|
| 61 | |
| 48 | |
| 26 | |
| 21 | |
| 20 |