In this blog, we are going to see how to compare the due date is today.
Most important thing in the date comparison is Date Format. If it is not matching the right date format then it will endup in error.
The SharePoint field "Due Date" is having the value in "M/d/yyyy" format, so the utcNow() date should also be in the same format, only then we will be able to compare it.
Ex: If the date is "07/06/2021", "MM/dd/yyyy" format will give you the result as "07/06/2021". But if the date format is set to "M/d/yyyy" you will get the date as "7/6/2021". That makes the difference.
The Formula in Filter Query for Due Date is equals to current date should be as shown below:
If you like this post, please do like, share, comment and subscribe.
You should take help from professionals who have immense experience on Power BI Implementation. They will help you with Solutions easily. Learn: Power BI Implementation
ReplyDelete