Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello. I want to make a minus sign in front of a value in a column that corresponds to a text value in another column. Shown under I want make a "-" sign in front of all the numbers in lots when buy or sell is sell?
Like this:
Buy | 2 |
Sell | -1 |
Sell | -3 |
Buy | 2 |
Sell | -1 |
Solved! Go to Solution.
Hi @LFM ,
There are multiple ways to achieve your required output, and one of them is to write a calculate column like below:
Sign = if('Table'[Text]="Sell",'Table'[Lots]*-1,'Table'[Lots])
I attach an example pbix file.
Best regards,
Minus sign in front of a value that corresponds to... - Microsoft Fabric Community
Hi,
You can create a calculated column as below:
ColumnName=
Proud to be a Super User! | |
Hi @LFM ,
There are multiple ways to achieve your required output, and one of them is to write a calculate column like below:
Sign = if('Table'[Text]="Sell",'Table'[Lots]*-1,'Table'[Lots])
I attach an example pbix file.
Best regards,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |