Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |