Forum Discussion
Sort column by today's date
Hello-
1) Create a custom column. Today's date =
DateTime.LocalNow()
2) Create a conditional column where Is today's date = Yes if today's date is equal to your date column and no if it isn't.
Jared
Thank you!
But actually i wish to filter Lease End date column where only filter dates which is upcoming not past date
See below snap, i wish to filter second column by first column.
I have already created column the way you suggested.
hope i clear in my results
please guide
hi, Anonymous
If Today's Date2 will be updated every day?
If so, create a conditional custom column that if Lease End date column is after Today's Date2, then 1 else 2.
Then you could filter this custom column which is 1.
Or use this formula to create a custom column
if [#"Lease End date -Copy"]>=Date.From(DateTime.LocalNow()) then 1 else 2
Then filter it by the same logic.
here is sample pbix file, please try it.
Regards,
Lin
i got the nearly answer of my query but when i tried to put condiationl formatting it's showing data from all quarters since 2019 to next expiring dates, please see the snap
hi, Anonymous
Could you please share the sample pbix file for us have a test? For it's showing data from all quarters since 2019, there should be something wrong in other.
Regards,
Lin
