Notifications
Clear all
Topic starter
26/04/2022 12:22 pm
Der Ausdruck ist ungültig bzw. möglicherweise unvollständig. Überprüfen und korrigieren Sie den Ausdruck.
Falsche Syntax für 'BLANK'. (DAX(if(NOT(ISBLANK([Sales_Amount_Ratio])),[Sales_Amount_Ratio]-1,BLANK()))).
Topic starter
26/04/2022 12:26 pm
The problem seems to be an issue with the German Excel version.
1. Make sure, that you use the "," (Comma) instead of ";" (Semicolon)
2. Strange, but add a " " (Blank) after the "," (Comma).
To do so, it should work.
= if ( NOT ( ISBLANK ( [Sales_Amount_Ratio] ) ) , [Sales_Amount_Ratio] - 1 , BLANK() )
