How can I create a dynamic table such that....

[pmusram]

Hi Community!!

I need help regarding creating a table in a dashboard such that the Measures I have created can be seen row-wise and measures like past 7 days, past 14 days and past 21 days would be column-wise. Kindly see a screenshot that I have attached.

(I have made all the measures which are shown below for 7days,14days,21 days)

[amitchandak · Accepted solution]

@pmusram , So you want to measure to dimension conversion ?

This means these split for measures. In that case, you need to create a table like one given below and use that

union(
summarize('Table',"Measure","App","Last 7 Days",[APP 7 Day],"Last 14 days",[APP 14 days],"last 21 Days",[APP 21 Days])
summarize('Table',"Measure","App","Last 7 Days",[Leads 7 Day],"Last 14 days",[Leads 14 days],"last 21 Days",[Leads 21 Days])
)

[pmusram]

@amitchandak Thanks it worked😊