Forum Discussion

powerbiAG's avatar
powerbiAG
Frequent Visitor
3 years ago

DAX in Power Query of Data Flow

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

dataflow
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.