Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

'FILTER' syntax is suddenly incorrect

Hi all,   I've been working with this particular report for quite some time. I created it ages ago and it has been reloading on a daily basis and people in my company are using it quite often. But ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    I was using another PC that had different settings, which messed up the distinction between ',' and ';'. My bad!
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

Relevant WO = 
MAXX(
    TOPN( 1, FILTER (
        WO,
        WO[I_DATE] <= MAX ( Calendar[Date] )
            && (WO[G_DATE] >= MIN ( Calendar[Date] ) || isblank(WO[G_DATE]) )
            && not(isblank(WO[I_DATE]))
    ), WO[I_DATE], DESC),WO[WO_CODE])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I don't know, it's still throwing the same 'The syntax for 'FILTER' is incorrect'-error... 😞 

     

    Please refer to the reply on the other provided solution. I have a feeling the problem is in the 'MAXX' and/or 'TOPN'.