Forum Discussion
Pivot table dates in multiple rows
Hi all, I have an excell query that look like this example: I am tyring to figure out how to transform data so that the table looked something like this: SKU Date Value AAA 25/0...
thanks dax for you help
I have tried to replicate your M code in my model, but it seems that I'm missing a step somewhere that makes not working.
https://www.dropbox.com/s/f00wqiizkmerat9/Forecast.pbix?dl=0
thank you very much
Reuben
AlB
Community Champion
Community ChampionHi Anonymous
the file you've attached doesn't show the source data because it is reading from your local folder. Can you paste here the source data (in txt-tabular format, so that it can be copied)? And what is it exactly in dax approach that is not working??
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers