Forum Discussion
Post PatronMeasure values based on DATE flag (slicer selection)
Hi,
I have created below calculated measures that will calculate values for current and previous days based on slicer Date selection. Is it possible to change the matrix table to below required format OR create a Date flag for Current, Previous 24 hrs to use with the measure to change the values dynamically. Thanks in advance !.
Current Format:
Required Format:
6 Replies
- amitchandak
Super User
kumsha1 , You have do measure to dimension converiosn. You have create a table like this and display that in matrix
union(
summarize('Table',"Measure","Sales Growth", "ACT",[Sales Growth], "PY",[Sales Growth PY], "FC",[Sales Growth FC]),
summarize('Table',"Measure","Price Growth", "ACT",[Price Growth], "PY",[Price Growth PY], "FC",[Price Growth FC])
) Hi kumsha1 ,
Based on your description, you can do some steps as follows.
- Spilt the first column.
- Create a table.
Table =
ADDCOLUMNS(
SUMMARIZE(table2,[attribute.1]),
"Prev", MAXX(FILTER(ALL(table2),[attribute.2]<>BLANK()&&[attribute.1]=EARLIER('table2'[attribute.1])),[percentage]),
"Current",MAXX(FILTER(ALL(table2),[attribute.2]=BLANK()&&[attribute.1]=EARLIER('table2'[attribute.1])),[percentage])
)
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kumsha1Hi Anonymous , thanks for your reply.
All the objects are calculated measures... Hence, not available for column formatting 😞
Hi kumsha1 ,
Can you kindly provide me your sample data model or sample data? It couldn't be better if you offer me your formula of calculated measures.
Best Regards,Yuna
