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])

Anonymous's avatar
Anonymous
Not applicable
3 years ago
last value (1) =
VAR __A =
MAX( 'Weekly average Packs Per Hr'[Week End Date] )
VAR __B =
CALCULATE(
MAX('Weekly average Packs Per Hr'[Week End Date] ) ,
FILTER(ALLSELECTED('Weekly average Packs Per Hr'), 'Weekly average Packs Per Hr'[Week End Date] < __A && 'Weekly average Packs Per Hr'[Weekly hourly average] <> BLANK() )
)
RETURN
IF (
ISBLANK ( MAX('Weekly average Packs Per Hr'[Weekly hourly average] )),
CALCULATE( MAX( 'Weekly average Packs Per Hr'[Weekly hourly average]), FILTER(ALLSELECTED('Weekly average Packs Per Hr'), 'Weekly average Packs Per Hr'[Week End Date] = __B ) ) ,
MAX('Weekly average Packs Per Hr'[Weekly hourly average] )
)