Measure values based on DATE flag (slicer selection)

[kumsha1]

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:

[v-yuaj-msft]

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

[kumsha1]

Hi @v-yuaj-msft , how can i share sample .pbix file with you?

[v-yuaj-msft]

Hi @kumsha1 ,

Please share me with your pbix file from your Onedrive for Business. (just post a link as a reply)

Best Regards,
Yuna 

[v-yuaj-msft]

Hi @kumsha1 ,

Based on your description, you can do some steps as follows.

1. Spilt the first column.

1. 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.

[kumsha1]

Hi @v-yuaj-msft , thanks for your reply.

All the objects are calculated measures... Hence, not available for column formatting 😞

[amitchandak]

@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])
)