Combining Value of Conditional Column and Calculated Column

[polaris3028]

Hi Guys,

I need your help.  I have a conditional column created using the Power Query Editor.  Now, there's another table where I created a calculated column (using Distinct Count). I'd like to combine the total of the Conditional Column and the Calculated Column, but it's not showing the value for the calculated column in a table.  Any idea?

[v-piga-msft]

Hi @polaris3028,

---

I'd like to combine the total of the Conditional Column and the Calculated Column, but it's not showing the value for the calculated column in a table.  Any idea?

---

What the mean of "it's not showing the value for the calculated column in a table"?

In addition, how do you want to combine the Conditional Column and the Calculated Column?

To get the solution better, please share some data sample and your desired output.

Best Regards,

Cherry

[polaris3028]

Hi @v-piga-msft - sorry for the late reply.

See below:

Basically, I just need the value of the Total Volume in FT-Dev table combined in the Consolidated Table where the Total Volume is a column already present in the datasource.  Hope this clarifies.

Thanks! 

Paul

[polaris3028]

Any admin please?