Forum Discussion

Pete230's avatar
Pete230
Helper III
3 years ago
Solved

Compare Date Column with current date

Hi guys,   I'm struggeling with the following: I would like to compare a date colum (last day of month) with the current month, if the current month is less or equal as the date colum then the numb...
Need Help
  • JavidM's avatar
    JavidM
    3 years ago

    Alternatively, you can use the following M code without converting the Date column into datetime format:

    = Table.AddColumn(#"Changed Type", "Custom", each if [Date] > DateTime.Date(Date.EndOfMonth(DateTime.LocalNow())) then 0 else [Amount])

     

    Hope this helps!

JavidM's avatar
JavidM
New Member
3 years ago

You can use the following M code:

= Table.AddColumn(#"Changed Type1", "Custom", each if [Date] > Date.EndOfMonth(DateTime.LocalNow()) then 0 else [Amount])

Bear in mind that you have to convert the date column to datetime format before applying the function.