Forum Discussion
Division
Hello,
I am trying to enter a new measure where I want to calculate a monthly usage based on a total annual number.
The column is called "Units Sold Sum" which I want to divide by 12.
The Units sold sum is already grouped and there are filter on the page.
bassplayer-nld , In measure you have use sum
Measure = Sum([Units Sold Sum])/12
I have written this for target, but that may work in your case
#PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
Hi bassplayer-nld ,
In measure, you need to use a summarisation on column name like SUM, MAX, etc.
You can also try using DIVIDE function.
Measure = DIVIDE(SUM([Units Sold Sum]), 12, 0)
Thanks,
Pragati
3 Replies
bassplayer-nld , In measure you have use sum
Measure = Sum([Units Sold Sum])/12
I have written this for target, but that may work in your case
#PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
Thank you
Hi bassplayer-nld ,
In measure, you need to use a summarisation on column name like SUM, MAX, etc.
You can also try using DIVIDE function.
Measure = DIVIDE(SUM([Units Sold Sum]), 12, 0)
Thanks,
Pragati
