BI Analysis of Date based Data

[Ganesh0510]

Hi,

I have following data type and want to analyse based on date. Any ideas please

[Ganesh0510]

Thanks boss, that did help. Unpivoting the columns.

[rubayatyasmin]

then please accept my answer as a solution. Thanks

[rubayatyasmin · Accepted solution]

Hi, @Ganesh0510 

did you thought about some transformation? do some unpivot in the date columns see if that helps. 

you can then perform tred analysis, forcasting etc.