Forum Discussion
multiple IF issue on DAX
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:
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('Dates réelles'[Promesses réelles]>TODAY()),1,0
))
but i have some error messages and its not working
Do you have an idea?
3 Replies
Hi,
Since BLANK will always be smaller than TODAY() you don't need ISBLANK and NOT. So try something like this:
formule 1 =
IF('Dates réelles'[Promesses réelles]>TODAY(),1,0)
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/Try using SUMX. So something like:
SUMX(Dates réelles,IF('Dates réelles'[Promesses réelles]>TODAY(),1,0))
