Forum Discussion
How can I create a dynamic table such that....
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 , 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])
)
amitchandak Thanks it worked😊