Forum Discussion

edhans's avatar
edhans
Community Champion
6 years ago
Solved

Convert boolean to scalar value?

This might be a simple question but it is eluding me, short of a longer measure (which I have already created), is there a single function to convert boolean field to a scalar value?   For example,...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi edhans ,

     

    You can use SELECTEDVALUE() function instead of MAX() function.

    Last Date Is Validated = CALCULATE(SELECTEDVALUE('Table'[Validated] ),FILTER('Table',LASTDATE('Table'[Date])=DATE(2018,2,1)))

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi edhans ,

 

You can use SELECTEDVALUE() function instead of MAX() function.

Last Date Is Validated = CALCULATE(SELECTEDVALUE('Table'[Validated] ),FILTER('Table',LASTDATE('Table'[Date])=DATE(2018,2,1)))

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

edhans's avatar
edhans
Community Champion
6 years ago

Thank you Jay. SELECTEDVALUE() seems to be exactly what I was looking for in this instance.