Forum Discussion

ManuBK's avatar
ManuBK
Frequent Visitor
5 months ago
Solved

Identifying State history Count based on date slicer

Hi ,   I have a requirement where in i need to identify the Old state count based on the date slicer.   I need to indentify the state count based on the date selection on that period    For exa...
Need Help
ManuBK's avatar
ManuBK
Frequent Visitor
5 months ago

Hi Kedar_Pande  Thanks for your reply .Apologise for late response. I have three questions on above measure

 

VAR SlicerMin = MIN('Date'[Date]) As this needs to be as calendar date right ?
[@State] = SELECTEDVALUE('State'[State])  The bold value is the old state or the new state as when i copy the code and placed in PBI it says Cannot find the name State

 

And for Calendar date which column has been used for a relationship -  Start date or New Start date ?