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... I'll simplify this by having only five columns within the SalesTransaction table:
TransDate (eg. 05/29/2018)
TransTimePeriod (eg. 06:30-07:00)
SaleAmount (eg. 200.00)
ThisWeek ( measure where = 1 when True)
LastWeek (measure where= 1 when True)
I also have a Date table.
I want to create a visual that shows the following:
Essentially I need to summarize the SaleAmount for each TransTimePeriod (easy so far), and then compare it for the same period last week (which is where I'm getting stuck).
Working solution! THX!
Here is a simplified example of the SalesTransaction table (it's a whole lot more sophisticated but this will do):
Date file is just a list of dates.
Hi @finzilla,
Please check the demo in the attachment.
1. I would suggest adding a column in the date table.
WeekNum = WEEKNUM([Date],2)
2. Create three measures.
Today = CALCULATE ( SUM ( Table1[SaleAmount] ), 'Calendar'[Date] = TODAY () )
LastWeek = CALCULATE ( SUM ( Table1[SaleAmount] ), 'Calendar'[WeekNum] = WEEKNUM ( TODAY (), 2 ) - 1 )
Variance = [Today] - [LastWeek]
Best Regards,
Dale
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |