How to reference the earliest date from transaction table in my rolling calendar query in M?

[gerdtf84]

Hello,

I have my rolling calendar table as a lookup, using a static start value.

Instead I rather use the earliest date from my transaction table, so when I build a date slice it fits perfectly.

How can I do that?

Thanks

[gerdtf84]

Hello Arul,

thank you for your help. That was exactly what I was looking for.
I tried to integrate step by step and I can retrieve the correct date. But I do not manage to integrate it into my rolling calendar.

this is what I have so far:

startDate = List.Min(Table.Column(#"Sales", "Date" )),
#"Create List Of Dates" = List.Dates(Number.From(DateTime.LocalNow())-Number.From({{startDate}}),#duration(1,0,0,0)),
#"Converted to Table" = Table.FromList(#"Create List Of Dates", Splitter.SplitByNothing(), null, null, ExtraValues.Error),

But I am getting an error cause it seem I am getting a List instead of a Date value. Can you give me a hand here as well?

Thanks a lot for your help.

[Arul · Accepted solution]

Hi @gerdtf84 ,

I hope that you need minimum date from transaction table. If I understood your problem correctly, then you try this,

List.Min(Table.Column(#"Transaction Table", "Date column" ))

Thanks,

Arul