Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert the below dax to m

How to write the below dax in power query ?   Account = CALCULATE ( FIRSTNONBLANK ( 'Discoverer-Payables'[Account], 1 ), FILTER ( 'Discoverer-Payables', 'Discoverer-Payables'[Concatenate Seg...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    You could add below codes to TableA. Modify the step and column names accordingly. Download the attached pbix for details. Let me know if you have any questions.

     

        #"Merged Queries" = Table.NestedJoin(#"Changed Type", {"No"}, TableB, {"No"}, "TableB", JoinKind.LeftOuter),
    #"Aggregated TableB" = Table.AggregateTableColumn(#"Merged Queries", "TableB", {{"Value", List.First, "Lookup Value"}})

     

    TableA: 'AP Payment 1 Matched'

    TableB: 'Discoverer-Payables'

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

     

     

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

You could add below codes to TableA. Modify the step and column names accordingly. Download the attached pbix for details. Let me know if you have any questions.

 

    #"Merged Queries" = Table.NestedJoin(#"Changed Type", {"No"}, TableB, {"No"}, "TableB", JoinKind.LeftOuter),
    #"Aggregated TableB" = Table.AggregateTableColumn(#"Merged Queries", "TableB", {{"Value", List.First, "Lookup Value"}})

 

TableA: 'AP Payment 1 Matched'

TableB: 'Discoverer-Payables'

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.