Forum Discussion
Calculating Sell-In since a specific launch date - NEED PRECIOUS HELP
Hi amitchandak !
Thanks for your help !
You could find below a sample data of what we use with no sensitive data...
Thank you so much for providing your help we have lot of stuggle in this task...
Hi, floppy_fish
Please check the below picture and the link down below.
One additional calculated column has been created in BoostSellIn table.
I think this column is the critical column in this case, because this column is used as X-Axis in the line chart.
https://www.dropbox.com/s/brwqn5m9mkjdv8m/floppyv2.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Super UserHi, floppy_fish
Please check the below picture and the sample pbix file's link down below.
My sample is to find the first 120 days sales qty after the first launching date.
I hope you can apply a similar logic to your case.
If you can share your sample pbix file's link, I can try to have a look and come up with more relevant measures.
In my fact table, you can see that I created a new column, which is the most important step in this case. Once this new column is created, then the next steps will become quite easy to move forward.
https://www.dropbox.com/s/arlbl9ymvs3qr5r/floppy.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi Jihwan_Kim
First of all, thank you so much for your help and the pbi exemple provide ! All my team are happy to feel support by you ! It's really appreciated..
Unfortunaly it doesn't work with our dataset... To avoid sharing sensible data, i provide you via this link below an exemple of the two main table where I'm working with (we have also a calendar table).
If the link doesnt work let me know if i can send you info by email ?
Tge goal is to have by month how much Sell-In we cumulated since the first date of launch...
The date of launch is on a other table...
But maybe if it takes into account the first date of sell-in in the boost tab it could works ?
Thanks again for your help !