Date.IsInPreviousNMonths Function in Power Query
The Date.FromText function creates a Date value from the text.
Syntax
Date.FromText(text as nullable text, optional options as any) as nullable date
Example: Convert "2024-12-31" into a date value.
Power Query M
let
return = Date.FromText("2024-12-31")
in
return The output of the above code is #date(2024, 12, 31).