How to Model Price Increase in Power BI || Data Modeling Case Study

Check out our newly launched M Language course ↗️ - goodly.co.in/l...
In this video I'll show, how data modeling can be creatively leveraged to solve a price increase problem in Power BI. I hope you find this useful.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/p...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@davitmovsesyan1088]

Great demonstration, thanks! However in real life pricing will have much complex granularity. It will be not only by month but also by product and customer etc.. In that case it doesn't make sense to use calendar table. Instead you will need to think about separate pricing table connected to all mentioned dimensions.

[@sanjeevsoni6793]

Creating Column in the Calander Table is brilliant Idea

[@giorgitsomaia2812]

Thanks for this video, can you make more complicated one? instead of increasing all items with same rate how do you do it with different rate with different items?

[@ishaqkhan8653]

Hi, I see that you have used M language to create the accumulator column, is there another way to create the accumulation column by using set of clicks in power query instead of m language as I don’t know M language

[@GoodlyChandeep]

goodly.co.in/learn-m-powerquery/?

[@rogervandecraen9797]

thanks for the clear explained video, I agree with davitmovsesyan for the more complex granularity where can we find a video on that particular problem?

[@Turbo_PilotSky]

Wouldn’t it much easier to add “ MMM-YY” column to Calendar table and link it with Price Increase table? I wouldn’t be adding anything that is not date related to the Calendar table , plus you would not need all the extra transformations to plug accumulated increase column to Calendar table .

[@guppi1]

I find it hard to follow the accumulation function 😢. List.Accumulate is so hard to understand to me

[@Jai_Radhe_Radhe]

Am unable to concatenate the list and table, can anyone help me out? = Table.FromColumns(Table.ToColumns(Renamed Columns1) & {Custom1}, Table.ColumnNames(Renamed Columns1)& (List) )

[@cathrerinezetadrones3169]

This works for one item, but we can have price increases on several items. Would you add additional accumulation columns? Or is there another way you would handle this?

[@GoodlyChandeep]

I would then create a product year month dim table..thatll make this ridiculously easy

[@diegoscalionitp]

@@GoodlyChandeep you mean a slowly changing dimension, right? That would be interesting to see. I usually find diifcult to create the Surrogate Keys on the Fact Table via Power Query without losing much performance.

[@rajageddam9101]

wow

[@stacyrodgers4051]

*promosm*

[@erivaldolopes632]

How would you model if you had the accumulator table as separated table instead with the dates where the increase happened?!

[@florincopaci6821]

Thank you for another amazing video. Please if it s possible came more often with problems like this. I will replicate this in sql and of course in Power Bi and Tableau Thank you

[@saichandu5965]

Great one! Can you able to show on how rate increase rsther percentage increase baded on revenue

[@mogarrett3045]

excellent tutorial bortha....thank you so much

[@chrism9037]

Wow, great solution Chandeep!

[@umeshlangade9231]

nice way to achieve things which seems complex in star schema 🙌

[@FRANKWHITE1996]

❤

[@adrianofrizon3514]

Great solution, but what if I have to increase price differently by each product of by each “product family”?

[@gerardotobar6905]

Same wish here to see this be solved!

[@pepper_lab]

Awesome thanks 👍👍👍

[@Jai_Radhe_Radhe]

Thanks got it

[@arghyadutta9091]

Great