Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a table with these columns:
Costumer | Date | Month Number | Sale
I would like to select an interval of date (slicer) and bring this number:
How many costumers have purchased at least 1 product in 3 differents months in that selected time interval
PS: sorry for my english, i'm brazilian
Solved! Go to Solution.
Hi @Anonymous ,
Based on your description, you need to create a what-if parameter as slicer.
Take what-if parameter value as the parameter of month interval in the formula.
Measure = COUNTROWS (
FILTER (
SUMMARIZE (
'Table',
'Table'[Costumer],
"count_month", CALCULATE (
DISTINCTCOUNT('Table'[Year month]),
DATESINPERIOD (
'Table'[Date],
MAX ( 'Table'[Date]),
- 'Month interval'[Month interval Value],
MONTH
)
)
),
[count_month]>=3
)
)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Try a measure like
Count(filter(summarize(Table, Table[Costumer], Table[Month Number], "_1", DistinctCount(Table[Month Number])), [_1] >=3),[Customer])
What do you mean with "_1"?
Hi @Anonymous ,
Based on your description, you need to create a what-if parameter as slicer.
Take what-if parameter value as the parameter of month interval in the formula.
Measure = COUNTROWS (
FILTER (
SUMMARIZE (
'Table',
'Table'[Costumer],
"count_month", CALCULATE (
DISTINCTCOUNT('Table'[Year month]),
DATESINPERIOD (
'Table'[Date],
MAX ( 'Table'[Date]),
- 'Month interval'[Month interval Value],
MONTH
)
)
),
[count_month]>=3
)
)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |