Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new to PowerBI so this might be pretty basic.
I want to create a new column where each row contains the result of diving the corresponding value in an existing column by 100.
I want to use QUOTIENT since I need only the integer part. But QUOTIENT only works with single values (aggregations). How would one use QUOTIENT (or any other math function) on each value of a column?
Solved! Go to Solution.
Refer
https://docs.microsoft.com/en-us/dax/quotient-function-dax
Create a new column not measure. I created one and able to get values for each row
Column = QUOTIENT(Sales[Sales Amount],100)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Refer
https://docs.microsoft.com/en-us/dax/quotient-function-dax
Create a new column not measure. I created one and able to get values for each row
Column = QUOTIENT(Sales[Sales Amount],100)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |