Forum Discussion

jgni's avatar
jgni
Frequent Visitor
9 years ago

How do I visualize only data which is never than yesterday?

Hi   Newbie here. I don't if it's smartest to do this in the web version or desktop. So I put my question here...   I have an Excel sheet, which contains a date field, and I only want to show the...
Need Help
jgni's avatar
jgni
Frequent Visitor
9 years ago

Hi

 

This gives me 4 rows:   #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [End] >= #date(2017, 3, 7))

 

But this gives me 0: #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [End] = Date.AddDays(DateTime.LocalNow(),-1))

 

??

 

Regards

Jan

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi jgni,

 

This gives me 4 rows:   #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [End] >= #date(2017, 3, 7))

But this gives me 0: #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [End] = Date.AddDays(DateTime.LocalNow(),-1))

The first one will get the records which date large than yesterday, the second one only get the equal data. If your requirement is filter data like first one, you can try to use below formula to make it dynamic get current date.

 

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [End] >= Date.From(Date.AddDays(DateTime.LocalNow(),-1)))

 

Regards,

Xiaoxin Sheng