Hi Kiran, I can ask any questions you have here, as long as they’re short and relevant to the video, If you need a more tailored support, I provide it as a service, through memberships, Hope that helps!
I have a situation like this, for calculating MoM and WoW, I need to consider same period in the previous year. Let's say if I want to return MoM for August 2021, then calculation would be like (Aug_2021 sales - Aug_2020 sales)/Aug_2020 sales * 100. Like this it should be dynamic for MoM and WoW and in the view I need to display like Last 12 months for MoM % growth, and Last 13 months for WoW % growth. I achieved the calculation but not able to restrict last 12 months/13 weeks. Any help on this would be helpful. Note: we are not supposed to use calendar table as per our requirement. So considering sales_date from data itself and I achieved WoW and MoM based on month_number and Week_Number. And based on maximum sales_date, we need to display last 12 months or Last 13 weeks.
For this youll need to use something like PREVIOUSYEAR in combination with the CALCULATE function something like this: ua-cam.com/video/dR-XmJil5DM/v-deo.html If you aren’t supposed to use calendar tables, you can try to create a MoM or YoY using quick measures
Perfect! thank you so much for this easy & fast solution, I've been struggling for a week now, wish I found this sooner.
Thanks for watching!
Your videos are really good and helps a lot. Reduces stress i have to say. Thanks
Thank you bro.
Very easy explanation, thanks for the video..
Glad it was helpful!
Thank you!
We need your help if we stucked with dax
Hi Kiran, I can ask any questions you have here, as long as they’re short and relevant to the video,
If you need a more tailored support, I provide it as a service, through memberships,
Hope that helps!
I have a situation like this, for calculating MoM and WoW, I need to consider same period in the previous year. Let's say if I want to return MoM for August 2021, then calculation would be like (Aug_2021 sales - Aug_2020 sales)/Aug_2020 sales * 100. Like this it should be dynamic for MoM and WoW and in the view I need to display like Last 12 months for MoM % growth, and Last 13 months for WoW % growth. I achieved the calculation but not able to restrict last 12 months/13 weeks. Any help on this would be helpful.
Note: we are not supposed to use calendar table as per our requirement. So considering sales_date from data itself and I achieved WoW and MoM based on month_number and Week_Number. And based on maximum sales_date, we need to display last 12 months or Last 13 weeks.
For this youll need to use something like PREVIOUSYEAR in combination with the CALCULATE function something like this: ua-cam.com/video/dR-XmJil5DM/v-deo.html
If you aren’t supposed to use calendar tables, you can try to create a MoM or YoY using quick measures
Multiple select value as a condition case?
May I know the difference between both
Hey fernan if we have any doubts how can we contact you
Hi Kiran, normally you can just reach out to me here in the comments, if it's anything related to the video I answer them here