Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!