Forum Discussion
Create row based data so table matrix can be created
I need to create a table that looks like the below but I can't because my data is structured differently Output I want: How my data is structured: The 2 metrics listed are calculated meas...
jnrezk , To me seems like measure to measure and dimension conversion
using a table like
union(
summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
)
union(
summarize('Table','Table'[country],"Revenue","sales","This period",[Revenue YTD],"Last period",[Revenue LYTD],"POP",[Revenue YOY])
summarize('Table','Table'[country],"Costs","unit","This period",[Costs YTD],"Last period",[Costs LYTD],"POP",[Costs YOY])
)
Not sure this is what im after