Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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]     '...
Need Help
Show and Tell
Tips and Tricks
ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

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/