Forum Discussion
Show category in Matrix table
Hello professionals, I have created a matrix table as below but I need to show like this so I need to to get a category lable for...
Hi jaipal
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou
Hi Anonymous, thank you for follow up, I have created 3 tables in power query (MTD, YTD, ITD) and append them and I got this output
now you can see all the values are same. The desired outcome is to get cumulative YTD or cumulative ITD.
I can do this in DAX, but I don't know how to calculate the tables within the power query.
My concern is to get the output through power query.
Thank you