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 Userfloppy_fish , this seems correct. Hope your displaying data by UPC and dates has been marked as date tbale
CALCULATE(
SUM(BOOST_Sell_In[Sell In (UN)]),
DATESINPERIOD(Dates[Date],MIN('Launch Timing'[Date of Launch]),12,MONTH))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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...