Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 < Dateparameter then "Over Due ".
If I pass the given date parameter
If dateparameter is 10/5/2017
After passing the date parameter getting below result :
duedatecolumn Parameter Status
26/10/2017 Notdue
25/10/2017 Notdue
10/5/2017 10/5/2017 Due
10/4/2017 Not Due
10/3/2017 Not Due
10/2/2017 NotDue
But Expecting the below result :
duedatecolumn Parameter Status
26/10/2017 10/5/2017 Notdue
25/10/2017 10/5/2017 Notdue
10/5/2017 10/5/2017 Due
10/4/2017 10/5/2017 Over Due
10/3/2017 10/5/2017 Over Due
10/2/2017 10/5/2017 OverDue
Based on the given parameter I should get the Status of Due, OverDue and NotDue,
But I am only getting the expected result when the parameter is equal to duedate.
Would Appreciate any help to solve the issue.
Thanks in Advance.
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |