March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello!
I had a client bases with all infos and another base with sales.
I wanna see if a buyer is new or bought something last month.
I can´t show my dataset, but I have a model:
Client
Sales
Buyers last month is a created column basically: IF((sum(Sales[Sales]), [Last Month Measure]) > 0,01, "Buyer Last Month", "New Buyer")
When I build a graph with Buyers( a distinct count for Code ins Sales table) in values, date in x axis and "Buyer Last Month" in legend, this is the result:
This is the expected result.
But I wanna make a dynamic report, that calculate buyers last month/new buyers for each month.
How can I do that?
The problem is not clearly enough defined to admit a unique solution.
Please consult this: New and returning customers – DAX Patterns
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
21 | |
14 | |
11 | |
8 | |
5 |
User | Count |
---|---|
26 | |
21 | |
20 | |
14 | |
10 |