I currently have several columns in powerbi:

'Dates réelles'[Promesses réelles]
'Dates recalées'[date agrement obtenu recalées]
'Dates recalées'[date signature de os recalées]
'Dates recalées'[date reception operation recalées]

and i want to obtain this:

[![enter image description here][1]][1]

which is approximately :

• formule 1 = IF [Promesse réelles] > Today; 1 ; 0
• formule 2 = IF formule 1= 0 and date agrément obtenu recalées > Today ; 1 ; 0
• formule 3 = IF formule 2 = 0 and date signature de os recalées > Today ; 1 ; 0
• formule 4 = IF formule 3 = 0 and date reception opérations recalées > Today ; 1 ; 0

There is a lot of blank cells so i have to considerate it

But i can't figure how to create my If function

I tried:

 formule 1  = 
IF(NOT(ISBLANK([Promesses réelles])>TODAY()),1,0
)

but i have some error messages and its not working, i obtain :

" Comparison dax formulas do not support comparing values ​​of type true/false with values ​​of type Date. Use the value or Format function to convert one of the values"

Do you have an idea? [1]: https://i.stack.imgur.com/fzUZD.png

CodePudding user response：

As the error message states, by writing ISBLANK([Promesses réelles])>TODAY() you're trying to compare the true/false value (ISBLANK([Promesses réelles] is an evaluation on its own and will return true or false) with a date value (TODAY()).

If you simply want to exclude blanks from your logic you can try this:

 IF(
    NOT(ISBLANK([Promesses réelles])),
    IF(
        [Promesses réelles]>TODAY(), 
        1, 
        0
       )
    )

If [Promesses réelles] is blank this formula will also return blank, if [Promesses réelles] is not blank and [Promesses réelles] > TODAY(), the formula will return 1. Will return 0 if [Promesses réelles] not blank and [Promesses réelles] <= TODAY().