Hi,
Looking to pull out revenue from a data table that is on or after a start date from my customer table. I am able to pull out the customer names no problem but only seem to be able to get total revenue and not from this date on wards (Each customer has a different date unfortunately).
I have a calendar table too and attempted these functions:
if(Data_Table[date]>=Customer_Table[Start date],Data_Table[Total Revenue]," ")
CALCULATE([Total Revenue], Data_Table[date]>=Customer_Table[Start date]
Any help would be great thanks!
Looking to pull out revenue from a data table that is on or after a start date from my customer table. I am able to pull out the customer names no problem but only seem to be able to get total revenue and not from this date on wards (Each customer has a different date unfortunately).
I have a calendar table too and attempted these functions:
if(Data_Table[date]>=Customer_Table[Start date],Data_Table[Total Revenue]," ")
CALCULATE([Total Revenue], Data_Table[date]>=Customer_Table[Start date]
Any help would be great thanks!