PowerQuery Calendar

[ovetteabejuela]

Help please...

I want the Starting date to lookup on a column (A Date column) from one of the Fact Tables and same goes with the End Date, How can I do that?

[MFelix]

Use the min and max function referenced to the column you want.

Regards

Mfelix

[ovetteabejuela]

I can implement this using DAX using what you suggested but I just don't know how to do it yet in Power Query.

How do I issue Min on a column found from another table? Add a parameter? Sorry absolutely no idea how.

[ovetteabejuela · Accepted solution]

Hahahaha, I just found out!

    StartDate = List.Min(Table.Column(Table,"DateColumn")),
    EndDate = List.Max(Table.Column(Table,"DateColumn")),