Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a small issue: my dataframe contains two columns - OrderedQuantity and DeliveredQuantity which contains decimal and integer values. I need to make a new column like this:
=0 in those rows where OrderedQuantity and DeliveredQuantity has integer values
= OrderedQuantity-DeliveredQuantity where OrderedQuantity and DeliveredQuantity has decimal values.
I was thinking about using ROUND() function:
= if [OrderedQuantity]<>ROUND(OrderedQuantity,0) and ... then [OrderedQuantity]-[DeliveredQuantity]
But it is not working. Can someone suggest other solution?
Thank you a lot
Hi SkaistePapuskai,
I tried the round function and it works, please try the formula when creating the column:
Column = if(value(Sheet1[Sales])<>round(Sheet1[Sales],0)&&value(Sheet1[Sales1])<>round(Sheet1[Sales1],0),
Sheet1[Sales]-Sheet1[Sales1],
0)
See the result:
If any further help needed, please feel free to post back.
Regards
If you don't need the decimals at all, you can format the data type of your columns to "WHOLE NUMBER".
@SkaistePapuskai Created calculated column as below,
= IF( IFERROR(SEARCH(".",YOUR COLUMN),0) > 0, RESULT IF DECIMAL, RESULT IF INTEGER )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |