Forum Discussion

polaris3028's avatar
polaris3028
Icon for Helper III rankHelper 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 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?

 

Need Help

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident 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
      Icon for Helper III rankHelper III
      8 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