Hi,
I have one requirement where I will calculate a column in SSAS tabular table for comparing two different years of data.
Since I need to compare 5 different years of data in the fact table I have splitted this into five different fact tables and calculated the comparison.
For e.g : For a student grade in 2015 is A+ and in 2014 is A. Then my calculated column in table 1 will have the value as A+:A.
For the same student grade in 2015 is A+ and 2013 is B, Then my calculated column in table 2 will have the value as A+:B
Similarly I will calculate for all the students and populate in the respective table as a column.Now I need to combine all the possible values from all the fact table(distinct rows) and create a dimension(or slicer) in powerpivot. Can anybody give suggestion on this.
Thanks
Arun