Forum Discussion

_Kevin_'s avatar
_Kevin_
Helper I
6 years ago
Solved

Use a measure result as a date

Hi   I have 2 measures as follows:   a) CurrentMonth = MAX((Info[Reporting Month])) - It renders "2020/04/30" and b) HCCurrentMonth = CALCULATE(SUM(HC_ACT[Headcount]),HC_ACT[TIME] = DATE(2020,0...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi _Kevin_ 

    try 

    HCCurrentMonth = 
var _CurrentMonth = MAX((Info[Reporting Month]))
RETURN

CALCULATE(SUM(HC_ACT[Headcount]),HC_ACT[TIME] = _CurrentMonth )

    or

    HCCurrentMonth = CALCULATE(SUM(HC_ACT[Headcount]),FILTER(HC_ACT, HC_ACT[TIME] = SELECTEDVALUE([CurrentMonth]) ))
az38's avatar
az38
Community Champion
6 years ago

_Kevin_ 

try MAX() instead of SELECTEDVALUE() as Tahreem24  mentioned

_Kevin_'s avatar
_Kevin_
Helper I
6 years ago

Hi az38 

 

I don't need either, I have now put the measure straight after "=" and it works too. 

 

regards

Kevin