Forum Discussion
Solved
Relative Date X Days Before
I'm very new to Power BI, so please be kind. I searched the board first but didnt find a similar post. Im playing around with a very basic report that gets data from our Active Directory. One column ...
I'm guessing that you have Date column in Datetime format. In "M", it is important to match data type for both left and right of the operator.
Then change it to...
= Table.SelectRows(#"Changed Type", each [Date] < Date.AddDays(DateTime.LocalNow(),-30))
I tried your suggestion and got this error
Expression.Error: We cannot apply operator < to types Date and DateTime.
I'm guessing that you have Date column in Datetime format. In "M", it is important to match data type for both left and right of the operator.
Then change it to...
= Table.SelectRows(#"Changed Type", each [Date] < Date.AddDays(DateTime.LocalNow(),-30))
Awesome, Thanks! I was just reading about that and noticed I had a DateTime field. Thanks for the fast replies. Still trying to get my head wrapped around this stuff. So much more involved that a tabel in Excel ;)