Forum Discussion

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
3 years ago
Solved

List.Tranform formula help

Hello M language wizards, I'll start by saying my M is pretty basic, and thus your help will be much appreciated! Need: create a list from one date to another, but only with the 1st of each month. ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You could try

    = Table.AddColumn(#"Custom", "Date_in_subscription", each

List.Distinct(List.Transform( { Number.From ( [Subscriptions.Start Date] ) ..Number.From ( [Subscriptions.End Date] ) }, each Date.StartOfMonth(Date.From (_)) )) )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could try

= Table.AddColumn(#"Custom", "Date_in_subscription", each

List.Distinct(List.Transform( { Number.From ( [Subscriptions.Start Date] ) ..Number.From ( [Subscriptions.End Date] ) }, each Date.StartOfMonth(Date.From (_)) )) )