Forum Discussion

fletch8527's avatar
fletch8527
New Member
7 years ago
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 ...
  • Chihiro's avatar
    Chihiro
    7 years ago

    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))
petrovnikitamai's avatar
petrovnikitamai
Resolver V
7 years ago
new column = IF(DATEDIFF(AD[date];TODAY();DAY)>30;AD[user];BLANK())

try to add new column.

 

if u want dinamicaly value instead 30 try to use what/if parametr