Forum Discussion

avkn4462's avatar
avkn4462
Regular Visitor
9 years ago
Solved

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 <...
  • spuder's avatar
    spuder
    9 years ago

    Hi avkn4462

     

    I tried it in Power Query and it worked.

     

    Try the settings as bellow

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

  • avkn4462's avatar
    avkn4462
    Regular Visitor
    9 years ago

    Hi v-yulgu-msft,

     

    Thank you for solution.

     

    It is working now.