DAX in Power Query of Data Flow

[powerbiAG]

We have developed a piece of DAX code to get (lookup) dates from another table and populate in current table...

screenshot below for reference.....

Can we do something similar in Power Query while loading data using Data Flow ?

Any guidelines or pointers in the right dierction would be much appreciated.

Thanks

[Anonymous]

Hi @powerbiAG 

You can refer to the following example

Sample fact table

Sample lookup table

To find the min date of the ID, then add it to the fact table.

Create a new custom clumn in fact table in power query

 Table.AddColumn(#"Changed Type", "Custom", each  Table.Sort(Table.SelectRows(Table , (x)=> x[Column1]=[Column1] ),{"Column2"})[Column2]{0} )

  Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.