Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to find the First Purchase Date for the customers.
So in the screenshot below, for this customer First Purchase Date is 4th Sep, but when I add Month Year to the table, the First Purchase Date gets updated to the Min(PurchaseDate) for that Month. I am trying to find the Transaction Frequency of the customer and this messes up my calculation. Could someone help me with fixing this ?
Thank you!
Solved! Go to Solution.
Hi,
Create a calculated column in your Customer Dimension as below:
CALCULATE (
MIN ( 'Date Table'[DateColumn] ),
RELATEDTABLE ( 'Pucrchase Fact Table' )
)
Then your problem would be solved.
Best Regards.
Thank you! They all are in a combined table. Should I create a date table which will make it easier ?
Yes it is better to make a separate dimension for that.
But If you don't want to create a dimension you can create a measure as below just based on your combined table:
VAR _CUSTOMER =
SELECTEDVALUE ( CustomerPurchaseFactTable[CustomerID] )
RETURN
CALCULATE (
MIN ( CustomerPurchaseFactTable[MonthYear] ),
FILTER (
ALL ( CustomerPurchaseFactTable ),
CustomerPurchaseFactTable[CustomerId] = _CUSTOMER
)
)
Regards,
Loran
Hi,
Create a calculated column in your Customer Dimension as below:
CALCULATE (
MIN ( 'Date Table'[DateColumn] ),
RELATEDTABLE ( 'Pucrchase Fact Table' )
)
Then your problem would be solved.
Best Regards.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |