Forum Discussion

msommerf's avatar
msommerf
Icon for Helper III rankHelper III
7 years ago
Solved

Calculating age from a date and time

Hi am fairly new to BI & DAX and am struggling to do what I think should be very simple.   I have the following measure: Selected Value = DATEVALUE(Format(SELECTEDVALUE('Year Analysis'[EOY Date])...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    msommerf  - One potential issue:

    The SELECTEDVALUE function only returns a value if there is a single value in the context. To make sure you only get a single value, you could use MAX instead.

    Hope this helps,

    Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

msommerf  - One potential issue:

The SELECTEDVALUE function only returns a value if there is a single value in the context. To make sure you only get a single value, you could use MAX instead.

Hope this helps,

Nathan

msommerf's avatar
msommerf
Icon for Helper III rankHelper III
7 years ago

Many thanks Nathan. This worked a treat!