Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Card showing an unknown value

Hi Bi Community. I have a table that has two columns: Column 1 = week end date Column 2 = value Both columns 1 and 2 are pulled from an excel spreadsheet dynamically. I'm using the measure...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    I think the problem is in ISBLANK function, that requires a column as argument

     

    NOT ISBLANK('Table'[Column])

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous ,

try this measure

Measure =
VAR _MaxDate = MAXX(
                   FILTER('Facts48',
                           NOT ISBLANK('Facts48'[Value])
                     ),
'Facts48'[Date]
)
RETURN
CALCULATE(MIN('Facts48'[Value]),'Facts48'[Date]=_MaxDate
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.