Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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).
and when i expand the month, should show input there.
@NILU090 , Assume value is a measure
Switch(true(),
isinscope(Date[Date]), [Value] ,
isinscope(Date[Month Year]),calculate([Value], lastdate(Date[Date]))
)
Hi @NILU090
You can refer to the following measure
Sample data
Measure = IF(ISINSCOPE('Table'[Month]),SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),'Table'[Month]=MAX('Table'[Month])))
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |