Help with the footfall conversion

[NaveenG]

Hi,

I am stuck with a problem.Please help

I have to show the conversion from footfall ,my dataset is in a single table where the enteries of footfall as well as conversion is stored.

Now the condition  for conversion is if a person bought scription/Trial on particular date and bought product on the same date and or after that it will be counted as converted.

Please help me how can I apply this in Dax.

[NaveenG]

Here is the data sample.

GuestCode	InvoiceDate	Marketbucket
SSNC26899	2023-06-01	Scription
SSNC26899	2023-06-01	PRODUCT
SSNC26899	2023-06-01	Fairness and Pigmentation
MMLC38880	2023-06-01	Scription
MMLC38880	2023-06-02	PRODUCT
MGLC246	2023-06-01	Scription

In this dataset firsts customer bought SCRIPTION and on the same day bought Product and another marketbucke(Fairness Pigmnetation ,this will be considered as converted,similarly second customer bought scritption on 1st and bought Product on 2nd this will also be counted as Converted.But the Third Customer only bought Scription it will not be counted as converted.

Hope this clarify my requirment.

[Idrissshatila]

Hello @NaveenG , 

Try including a sample data explaining what you want to acheive.

Also, I would recommend to work your data Model as a star schema and not keeping it as one table for better performance.

Learn about Star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin