Forum Discussion

vitinho's avatar
vitinho
Icon for Helper I rankHelper I
9 years ago

Making SUM between not related tables

Hello All,

I'm trying to copy the SUM of a GA (Google Analytics) extraction, in another extraction (Google doesn't allow to ave both informations in the same extraction) and I can't make an relation between both.

The first table in the first row is  the values I want ('GA Custo' by Can x Product Revenue), the other tables are the calculated collums  trying to simulate ("GA Agora vai" by Can x Product Revenue from 'Ga Custo'). The second row has my ultimate go (Date x CAn x Product Revenue).
But the DAX formulas are showing $ trillions, instead of millions. What I'm doing wrong? Is there a way to calculate that?

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi vitinho,


    But the DAX formulas are showing $ trillions, instead of millions. What I'm doing wrong? Is there a way to calculate that?

    What do you mean about "the DAX formulas are showing $ trillions, instead of millions"? Do you need to change the format of the measure shown on the report? Or the values of the measure are not right, and need to be changed from trillions to millions? Could you be more precisely with this?:smileyhappy:

     

    If you need to change the format of the measure shown on the report, you can go to Format tab -> under Data label -> then change the Display units to get your expected result.

     

    Regards