Forum Discussion
Formula calculating market share
Hi im trying to figure out a way to identify market shares for each day for each company + month to date and year to date.
I have a big data set with multiple companies and dates, but I will use this as a simple example:
I want my outcome to look something like this:
Any idéas? I will appriciate any help!
Anonymous , You can create a measure like
divide(sum(Table[Revenue]),calculate(sum(Table[revenue]), removefilters(table[Company]))
then use this measure with day, Month and Year in row of matrix visual
Adding MTD and YTD like that would be challenging
3 Replies
- amitchandak
Super User
Anonymous , You can create a measure like
divide(sum(Table[Revenue]),calculate(sum(Table[revenue]), removefilters(table[Company]))
then use this measure with day, Month and Year in row of matrix visual
Adding MTD and YTD like that would be challenging
CNENFRNLCommunity Champion
Formula worksheet formula is enough to deal with such simple question,
amitchandak works great, thank you very much!