Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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
No, MS is one product, 01 is Jan, 22 is year 22, so MS0122 means, MS sales in Jan 22 and Likewise
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |