Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
abhinavsahu
New Member

Power BI Measure creation

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.

abhinavsahu_0-1686228528529.png

this is how my data set look like.

grateful if anyone can help

Regards

Abhinav

2 REPLIES 2
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.