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.
Hello, everybody,
I created weekly coin sales and showing this week and previous week coin sales. Now to see both week, we need to click two weeks in a slicer part.
But my customer wants to click just once on a filter choosing just one week, previous week appear automatically.
Is there any method to click just one and see with previous week cooin sales as well?
Thank you always.
hi @Anonymous ,
Please use the below Dax formula to make new MEASURE to calculate last week sale.
lastWeek_Sales =
VAR WeekNum_LastWeek =
WEEKNUM ( TODAY () ) - 1
RETURN
CALCULATE (
SUM ( 'table'[Sale] ),
WEEKNUM ( 'Table'[Date] ) = WeekNum_LastWeek
)
You can use this measure too show last week count when this week filter is selected.
do not hesitate to give a kudo to useful posts and mark solutions as solution.
Regards,
Gaurav Raj Singh
LinkedIN : https://www.linkedin.com/in/gauravrajsingh/
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |