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!

Pete230's avatar
Pete230
Helper III
3 years ago

Thank you for your answer. I would like to create the same in M (Power Querry) not in DAX, I wasnt pricise on that. Do you know that as well?

 

Thank you!