Forum Discussion
Help Plz
Anonymous
What I mean by no success is that the formula now returns 300 rows al with the value 'Te laat' and all have the stagename 'Bid Made' so that part works.
However if i check the closedate on these 300 rows the date doesn't match because there are rows in the result with the date of 25th of oktober and beyond.
So there is something wrong with the second part of the formula
Column = IF(
Project[StageName] = "Bid Made" &&
Project[CloseDate] <= TODAY();
"Te laat";
BLANK()
There's nothing wrong with that formula. Are you sure the date column you're checking is properly formatted as a date? If your system and that column disagree about date-month order it could be reading those dates incorrectly. Either that or those dates later than October 25th are in a different year and you didn't notice.
Anonymous
Ive already tried to correct that but unfortunately with no succes.
Column = IF(AND(PROJECT[StageName]="Bid Made"; Project[CloseDate] <=TODAY()); "Te laat";"")
Am i forgetting something ?
No success in what way? What result are you getting now?
I really don't like the AND or OR functions anyway. It's easier to read if you use the operators && for AND, || for OR. Also I don't recommend using the Excel style "" in DAX in most cases. Use BLANK() instead, especially in a column where you want null values.
Column = IF( Project[StageName] = "Bid Made" && Project[CloseDate] <= TODAY(); "Te laat"; BLANK() )
RvdHeijden One thing to consider that would pass the condition in the formula is a blank CloseDate!
But you should not be getting any dates after today to pass (see picture)
Column = IF ( Project[StageName] = "Bid Made" && Project[CloseDate] <= TODAY (), "Yes", BLANK () ) Column 2 = SWITCH ( TRUE (), ISBLANK ( Project[CloseDate] ), BLANK (), Project[StageName] = "Bid Made" && Project[CloseDate] <= TODAY (), "Yes", BLANK () )Anonymous
What I mean by no success is that the formula now returns 300 rows al with the value 'Te laat' and all have the stagename 'Bid Made' so that part works.
However if i check the closedate on these 300 rows the date doesn't match because there are rows in the result with the date of 25th of oktober and beyond.
So there is something wrong with the second part of the formula
Column = IF(
Project[StageName] = "Bid Made" &&
Project[CloseDate] <= TODAY();
"Te laat";
BLANK()There's nothing wrong with that formula. Are you sure the date column you're checking is properly formatted as a date? If your system and that column disagree about date-month order it could be reading those dates incorrectly. Either that or those dates later than October 25th are in a different year and you didn't notice.
Hi RvdHeijden,
The formula should work. Could you post your table structures and some sample data which can reproduce this issue in your case? It's better to upload a sample pbix file.:smileyhappy:
Regards
Anonymous v-ljerr-msft Sean
Its kinda embarassing but you were right the 25th of october was in 2015......
I checked the dates and the formula works excellent, thank you all for the help
