Forum Discussion
Adding multiple columns in matrix view
Hello pranesh246 ,
Looks like you need to create measure with help of DAX for all the required columns and pull them individulally one by one.
You can use time intelligence functions from below link:
https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax
Thanks!
Hi Shishir22 ,
Unfortunately, I am able to add measures only as a row in matrix but the requirement is to add current, prior week, MoM, YoY, WoW measures in columns .
Hello pranesh246 ,
Can you please try dragging all the measure one by one in Values section of the matrix?
It should give you requried output.
Thanks!
Hi Shishir22 ,
It doesn't work because when I do that, measures are getting added on rows and not across the columns. I need to add measures across the columns which calculates value for respective rows.
Current week Prior week Same week last month Same week last year Month on Month Year on Year Week on week Metric 1 Metric 2 Metric 3