Dax function Revenue from a start date

[HFish]

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!

 

[akice]

You haven't provided much information about how your model is setup or how you want the final table to look, but assuming you have the Calendar_Table related to Data_Table correctly and have the Customer_Table on the rows, then although i have not tried it this measure should do what you want:

Total Revenue since start date := [COLOR=#333333]CALCULATE([Total Revenue], FILTER ( ALL ( Calendar_Table), Calendar_Table[date]>= MAX ( Customer_Table[Start date] ) ) ) [/COLOR]

where:

Total Revenue := SUM ( Data_Table[Revenue] )

This is Total Revenue per customer after their respective start date. But i feel like i am missing either how you want it to look or the calculation you are looking for because realistically you don't even need to test the date in my scenario shown above...

 

[HFish]

This works! Thank you so much!