To add max date from a table to date table

[ansar]

Hi ,

Can any one help here to update the coding in advance editor.

Source = 01/08/2019
add dates until today = List.Dates(Source, Number.From(DateTime.LocalNow())+1- Number.From(Source), #duration(1,0,0,0))

I have a fact table Data in that a column contains date [Pstng Date], i want my calander table always take the max date from Data[Pstng Date] not current date.

Regards,

Ansar.

[yaak · Accepted solution]

Ansar,

You can use: List.Max(Data[Pstng Date])

If you want to have a list of dates from tha maximum [Pstng Date] date until today you can use:

let
    Source = List.Max(Data[Pstng Date]),
    AddDates = List.Dates(Source, Number.From(DateTime.LocalNow())+1- Number.From(Source), #duration(1,0,0,0))
in
    AddDates

 You can minimise it to a single line like this: 

Source = List.Dates(List.Max(Data[Pstng Date]), Number.From(DateTime.LocalNow())+1- Number.From(List.Max(Data[Pstng Date])), #duration(1,0,0,0))

If you want to create list of dates from some 'fixed' date (or linked to some other parameter) until the maximum date in [Pstng Date] column, then you can use this:

let
    Source = Date.From("01/01/2020"),
    AddDates = List.Dates(Source, Number.From(List.Max(Data[Pstng Date]))+1- Number.From(Source), #duration(1,0,0,0))
in
    AddDates

I hope that helps,

Piotr

[yaak · Accepted solution]

Ansar,

You can use: List.Max(Data[Pstng Date])

If you want to have a list of dates from tha maximum [Pstng Date] date until today you can use:

let
    Source = List.Max(Data[Pstng Date]),
    AddDates = List.Dates(Source, Number.From(DateTime.LocalNow())+1- Number.From(Source), #duration(1,0,0,0))
in
    AddDates

 You can minimise it to a single line like this: 

Source = List.Dates(List.Max(Data[Pstng Date]), Number.From(DateTime.LocalNow())+1- Number.From(List.Max(Data[Pstng Date])), #duration(1,0,0,0))

If you want to create list of dates from some 'fixed' date (or linked to some other parameter) until the maximum date in [Pstng Date] column, then you can use this:

let
    Source = Date.From("01/01/2020"),
    AddDates = List.Dates(Source, Number.From(List.Max(Data[Pstng Date]))+1- Number.From(Source), #duration(1,0,0,0))
in
    AddDates

I hope that helps,

Piotr

[ansar · Accepted solution]

@yaak Thanks Dear !! below is what exactly required.

let
    Source = Date.From("01/01/2020"),
    AddDates = List.Dates(Source, Number.From(List.Max(Data[Pstng Date]))+1- Number.From(Source), #duration(1,0,0,0))
in
    AddDates

Regards,

Ansar.