Notifications
Clear all

[Solved] Falsche Syntax für 'BLANK'

 

Joined: 9 years ago
Posts: 17
Topic starter  

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()))).


Quote
Joined: 9 years ago
Posts: 17
Topic starter  

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

 


ReplyQuote
Share: