Forum Discussion

dtango9's avatar
dtango9
Helper II
6 years ago

Adding columns from visual table

Hello,

 

I'm looking to create a new column that I will add to an existing visual table on report view.  I'm looking to add 2 columns from that same visual table that I have made.  The columns are both distinct counts of dates.  Any help with the formula?

Thank you!

 

 
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    dtango9 , No very clear. You need to provide the exact formula you need

     

    You can create new measure

    Distinct Date = calculate(distinctcount(Table[Date]))

    New Measure = sum(Table[Phone Call]) + sum(Table[Appointments])

    • dtango9's avatar
      dtango9
      Helper II
      6 years ago

      I get this error when I created your new measure suggestion:

       

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi dtango9 ,

         

        You may create relationship between the table phonecalls and appointments with "Both" Cross filter direction, then create measure like DAX below.

         

        No. Connects = SUM ( phonecalls[actualend] ) + SUM ( appointments[scheduledend] )

         

        Best Regards,

        Amy 

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.