Forum Discussion
Use a date value to transform an integer - cannot convert value 'September' of type Text to type Int
Hi all, i am new to PowerBI. I receive a date value from our database as well as an integer (number of days to deadline). The problem is, that this value is always positiv, also when the deadline i...
I think you can simplify the date comparison and it will reduce to this:
anpVerzug = IF(AND(qryAuftraegeAnDisplays[Starttermin_Plan] < TODAY(), NOT ISBLANK(qryAuftraegeAnDisplays[Starttermin_Plan])), qryAuftraegeAnDisplays[Verzug] * -1, qryAuftraegeAnDisplays[Verzug])I haven't tested it, try it out