Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
Solved! Go to 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 , 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])
)
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |