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
Both formulas give the same result and both aren't working properly.
The formula begins that IF the StageName is 'Bit Made' then it should check the close date. However this formule seems to ignore the first part of the formula.
I have the tekst 'Te laat' on rows with the status 'Order' or 'Order withdrawn' and that is strange seeing the formula should only do something IF the value is 'Bit made' so how come it works on other values ?
That's not the way you've written the formula. You used OR, meaning that if either one of the two conditions is met it evaluates as true. For what you're describing now you would have to use AND.
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
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 ?
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
