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 All,
I have to filter my the report within the current date and it should not exceed the current date and display the date.I have found the below query as a solution
= Table.SelectRows(#"Renamed Columns1", each [Appointment Date By] <= Date.From(DateTime.LocalNow()))
but the query throws a error "We cannot apply operator < to types Date and DateTime.
Details:"
I am new to power BI , can anyone please let me know whether a solution is possible?
Kind Regards,
Anna
Solved! Go to Solution.
Hi
I got a solution by using the below code
= Table.SelectRows(#"Changed Type", each [Appointment Date By] <= #datetime(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()) ,Date.Day(DateTime.LocalNow()), 23, 59, 0))
Now the date has been filtered !!
- Anna
= Table.SelectRows(#"Expanded NewColumn", each [Repair Completion Date] <= Date.From(DateTime.LocalNow()))
i ran this and had no issues on it - my repair completion is a DateTime
Proud to be a Super User!
Hi
I got a solution by using the below code
= Table.SelectRows(#"Changed Type", each [Appointment Date By] <= #datetime(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()) ,Date.Day(DateTime.LocalNow()), 23, 59, 0))
Now the date has been filtered !!
- Anna
Hi
I got a solution by using the below code
= Table.SelectRows(#"Changed Type", each [Appointment Date By] <= #datetime(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()) ,Date.Day(DateTime.LocalNow()), 23, 59, 0))
Now the date has been filtered !!
- Anna
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |