Forum Discussion

dgelfuso's avatar
dgelfuso
Icon for Helper I rankHelper I
5 years ago

Dividing columns from two calculated tables

I have a Dates table, a bookings table, and a sales table.   I created two tables which summarize total bookings and total sales by EOM (End of Month from the Dates table):  EOM = EOMONTH(Dates[D...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Please share some data and show the expected result.

  • dgelfuso's avatar
    dgelfuso
    Icon for Helper I rankHelper I
    5 years ago

    I would like the data to look like below and then be able to divide Total Bookings by Total Sales for each EOM.

     

    EOM

    		Total BookingsTotal Sales
    10/31/2020100,000,000.00120,000,000.00
    9/30/202090,000,000.00 110,000,000.00