Forum Discussion

FuzzyYabs's avatar
FuzzyYabs
Frequent Visitor
7 years ago
Solved

Create a calculation based on two tables

Hello Power Bi Gurus!    Would need your help on something.  I currently have two tables, Revenue Individual (1) and Revenue Collection (2). I need these two tables to create a third table, Revenu...
Need Help
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi FuzzyYabs 

     

    Please check the measures in attachment.

    AC Power Rate = 
DIVIDE (
    CALCULATE ( SUM ( Individual[Amount] ), Individual[Department] = "AC POWER" ),
    CALCULATE (
        SUM ( Total[Total] ),
        FILTER (
            ALL ( Total ),
            Total[Department Total] = "AC POWER"
                && Total[Date] <> "NOV C18"
        )
    )
)

    Regards,

    Cherie

FuzzyYabs's avatar
FuzzyYabs
Frequent Visitor
7 years ago

Hi v-cherch-msft 

 

Almost! haha however, how am I suppose to make the calculation such that the totals will only be for a selected date range? ex. the total should be the sum from Nov 2017 - Oct 2018??? 

 

Apologies for having to many questions about this and thank you for helping me on this. 

  • FuzzyYabs's avatar
    FuzzyYabs
    Frequent Visitor
    7 years ago

    Hello v-cherch-msft 

     

    Your samples are very helpful. I will look into your suggestions. Thank you so much! 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi FuzzyYabs 

     

    Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

     

    Regards,

    Cherie