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

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

 

NOT ISBLANK('Table'[Column])

Anonymous's avatar
Anonymous
Not applicable
3 years ago

mangaus1111 still no joy. same syntax error. 

Measure = 
VAR _MaxDate = MAXX(
        FILTER('Weekly average Packs Per Hr',
            NOT ISBLANK('Weekly average Packs Per Hr'[Weekly hourly average])
        ),
'Weekly average Packs Per Hr'[Week End Date]
)
RETURN
CALCULATE(MIN('Weekly average Packs Per Hr'[Weekly hourly average]),'Weekly average Packs Per Hr'[Week End Date]=_MaxDate
)