Forum Discussion

polaris3028's avatar
polaris3028
Helper III
8 years ago

Combining Value of Conditional Column and Calculated Column

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 c...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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's avatar
polaris3028
Helper III
7 years ago

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's avatar
    polaris3028
    Helper III
    7 years ago

    Any admin please?