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 need help how to get two types of data in PB
Data I have in a table: Customer name, customer ID, Date of purchase, Year
To achieve this, you can create a new column in your table using Power Query Editor that categorizes each customer based on their purchase history. Here's a possible approach:
With this setup, you should be able to select a year in the slicer and see which customers are new, repeating, or old for that year.
Hi, thank you
just addtional question, I am getting this error
"Expression.Error: The name 'Previous Steps' wasn't recognized. Make sure it's spelled correctly."
I do not see where did we defined what are Previos Steps maybe I am missing something.
Hi,
try this measure:
Hi @lridicki
I think you can find answers to your questions in this article : https://www.daxpatterns.com/new-and-returning-customers/
Best,
Hi,
Thank you.
I will check this articul.
BR
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |