Power Platform Community Forum Thread Details

Dear Microsoft Power Automate Community,

Refer to my existing post in Combine Two DAX Queries into One CSV Table, and La... - Page 3 - Power Platform Community (microsoft.com), I'm still having issue to combine two DAX queries into one single CSV table.

I believe my condition was set correctly, because if I change the condition based on @v-yueyun-msft advice, the csv file has reversed the display of 2 DAX queries (see the screenshot below) and the figure "135150" for total of [Sum of Quantity] is still missing.

I have rollbacked my condition as followed which displayed the correct 2 DAX queries in the correct position in csv file except the missing figure "135150":

Condition:

Dataset 2a Rows > Dataset 2b Rows

If Yes, Select 2a:

range(0,length(outputs('Run_a_query_against_a_dataset_2a')?['body/firstTableRows']))

concat(split(body('Create_CSV_table_2b'), decodeUriComponent('%0D%0A'))?[item()], ',,,', split(body('Create_CSV_table_2a'), decodeUriComponent('%0D%0A'))?[item()])

If No, Select 2b:

range(0,length(outputs('Run_a_query_against_a_dataset_2b')?['body/firstTableRows']))

concat(split(body('Create_CSV_table_2a'), decodeUriComponent('%0D%0A'))?[item()], ',,,', split(body('Create_CSV_table_2b'), decodeUriComponent('%0D%0A'))?[item()])

For another DAX query for Dataset 1a Rows and Dataset 1b Rows, I put the similar conditions as below.

Condition:

Dataset 1a Rows > Dataset 1b Rows

If Yes, Select 1a:

range(0,length(outputs('Run_a_query_against_a_dataset_1a')?['body/firstTableRows']))

concat(split(body('Create_CSV_table_1b'), decodeUriComponent('%0D%0A'))?[item()], ',,,', split(body('Create_CSV_table_1a'), decodeUriComponent('%0D%0A'))?[item()])

If No, Select 1b:

range(0,length(outputs('Run_a_query_against_a_dataset_1b')?['body/firstTableRows']))

concat(split(body('Create_CSV_table_1a'), decodeUriComponent('%0D%0A'))?[item()], ',,,', split(body('Create_CSV_table_1b'), decodeUriComponent('%0D%0A'))?[item()])

Then, this csv file has 2 issues:

1) The DAX query on the right-hand side has misalignment after row 7.

2) The figure of 119,660 for the total [Quantity] is missing for DAX query on the right-hand side.

If I change the flow actions by adding additional "Select" actions after "Run as query against a dataset" actions (refer to the screenshot below), I could see the figure "135150" in "Select 2b" and "Create CSV table 2b" actions, but it went missing after the "Condition" action.