Forum Discussion
Metrix expand and collaps
I have used Metrix in power bi. Input shows that metrix here. When i collaps month should show output. Output will be based on latest date of that month's value ( as you can see highlited in green)....
NILU090 , Assume value is a measure
Switch(true(),
isinscope(Date[Date]), [Value] ,
isinscope(Date[Month Year]),calculate([Value], lastdate(Date[Date]))
)