Forum Discussion
Check Date if Falls from previous and current month dates
Hello, Im just having a hard time how to come up the results. I have column date, i wanted to check if it falls from date range 26th from previous month until 25th of the current month. ...
Use this formula in a custom column
= Date.ToText(Date.AddDays([Date],-25),"MMM")See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ3MtU3MjAyUorVAfPMEDwjfVNkjgkyxwhFClWXkTmCZ4yi0hihMhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}), #"Added Custom1" = Table.AddColumn(#"Changed Type", "Month", each Date.ToText(Date.AddDays([Date],-25),"MMM"), type text) in #"Added Custom1"
Hi Anonymous ,
- Method1: Add a column in Power Query:
[
d=Date.Day([Date]),
f=if d>=26 then [Date] else Date.AddMonths([Date],-1),
m=Text.Start(Date.MonthName(f),3)
][m]
- Method2: Add a column using DAX:
Month =
var _m=IF(DAY([Date])>=26, MONTH([Date]), MONTH([Date])-1)
return FORMAT( CONVERT(_m &"/1",DATETIME),"mmm")
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.