Hi!I have two tables - one with Queries by guests, one with Sales to guests.
I need to be able to count, within a given date range, how many Queries converted to Sales.If a Sale date is BEFORE a Query date, that Sale does not count for the given query.In the Sample provided, I am looking for the answer '5.'
Try a measure like
var _cnt = count(Filter(Table2, Table1[Contact ID] = Table2[ContactID] && Table2[Date] > Table1[Date]), Table2[Date])
Plot with columns from Table 1 columns
Hi @amitchandak , and thank you for this explanation...When I get to the red part from your sample formula (repasted below) I am unable to add a table name - I can only add an existing measure. Do you have any suggestions for what I might look at?
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.