Forum Discussion
avkn4462
9 years agoRegular Visitor
Date Parameter comparison with existing Date column
Hi, I have an issue with comparing input date parameter with existing date column. Suppose, If DueDate > Dateparameter then "Not Due " If DueDate = Dateparameter then "Due " If DueDate <...
- 9 years ago
Hi avkn4462,
In my test, I could get desired Status for each duedatecolumn value.
In your scenario, please check whether the date format stored in duedatecolumn is the same as parameter date. And make sure the data type of duedatecolumn and parameter are both set to date. Also, what is the regional setting in your .pbix file, is it the same as where you stored source data (duedatecolumn).
Since I could not reproduce your issue, it would better you can share your pbix file for further analysis.
Regards,
Yuliana Gu