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