Forum Discussion
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...
I think the problem is in ISBLANK function, that requires a column as argument
NOT ISBLANK('Table'[Column])
mangaus1111, thank you for your response. I've tried it but now getting a syntax error and cannot figure out why. Any ideas? I'm new to power Bi. Sorry.
Measure =
VAR _MaxDate = MAXX(
FILTER('Weekly average Packs Per Hr',
NOT ISBLANK('Weekly average Packs Per Hr')
),
'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
)
- mangaus1111
Solution Sage
I think the problem is in ISBLANK function, that requires a column as argument
NOT ISBLANK('Table'[Column])
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 )mangaus1111 It works. despite the error the measure actually works when I pull it onto a card.
thank you so much for your help.