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 everyone,
I would like to calculate
Q1. total count of visit;
Q2. total spend
for each user on the last 3 months, last 6 months and last 9 months.
Filter created:
3 filters are required as per user requested.
Formula applied for time period:
Last 3 months: EOMONTH(TodayDate, -3)
Last 6 months: EOMONTH(TodayDate, -6)
Last 9 months: EOMONTH(TodayDate, -9)
Date Outcome:
Last 3 months: From 1 December, 2022 until yesterday
Last 6 months: From 1 September, 2022 until yesterday
Last 9 months: From 1 June, 2022 until yesterday
Sample Data:
Expected Outcome:
When user selected Time Period = "Last 3 Months" and Frequency = "2 to 4 times"
When user further filter by selected Amount = "RM100 and below"
Does anyone have any ideas what kind of formula I should apply?
Any help would be much appreciated.
Thanks in advance!
Kindly Regards,
Milan
Solved! Go to Solution.
Hi @Milan14 ,
I have created a simple sample, please refer to my pbix file.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Milan14 ,
I have created a simple sample, please refer to my pbix file.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
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 |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |