Forum Discussion
Help with the footfall conversion
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.
2 Replies
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 👍
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.
