Forum Discussion
Percent difference for two average scores
Super UserAnonymous , In power query use split by a delimiter and use the last delimiter
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
Then these two will separate out
then create a diff measure
calculate(Sum(Table[Score]), filter(Table, Table[Category] = "Before")) - calculate(Sum(Table[Score]), filter(Table, Table[Category] = "After"))
or
calculate(MAx(Table[Score]), filter(Table, Table[Category] = "Before")) - calculate(MAx(Table[Score]), filter(Table, Table[Category] = "After"))
Hi amitchandak,
I believe i might missing a step.
Split by Tab did not split the columns. However, split by space almost did the trick.
I created a custom column to accomplish what I think is the point of the split column.
I created this calculation, using your DAX as a guide. In my calculation, I used Now instead of After.