Power BI Measure creation

[abhinavsahu]

HI all,

I have a dataset , in which i have many columns which indicates, sales of various products for different months, one column for one product , on emonth and like wise.

The rows contains, various distributers of various companies which have been further classifed based upon location, trading are etc.

I want to create a measure which will show me change in market share of each company , product wise wr.t last year same month. 

i further want to drill this down on the basis of various paramters like class of market, district etc.

Can any one help me.

this is how my data set look like.

grateful if anyone can help

Regards

Abhinav

[amitchandak]

@abhinavsahu , if MS0123, MS0122 are products, then you need to unpivot such columns in power query and you can get % of total or subtotal

Learn Power BI: Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

[abhinavsahu]

No, MS is one product, 01 is Jan, 22 is year 22, so MS0122 means, MS sales in Jan 22 and Likewise