Forum Discussion
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 Seg1,Vendor No,Cheque No] = 'AP Payment 1 Matched'[Concatenated Seg1,Vendor No,Cheque No]
)
)
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.
1 Reply
v-jingzhangCommunity Support
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.