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.
How to get Last week sales for previous year ?
@amitchandak @Sahir_Maharaj @Greg_Deckler @FreemanZ @Ashish_Mathur @olgad @tamerj1 @andhiii079845
Again, please a full example. This is completely unclear what your problem is.
Proud to be a Super User!
Please a example with some underlaying data and what do you want. Please read the pinned post how to ask for help.
Proud to be a Super User!
@saurabhtd This works well if you have disconnected date dimension table
Measure =
VAR _selectedDate = Today() //SELECTEDVALUE(dimDate[Date])
VAR _startDate = (_selectedDate-(WEEKDAY(_selectedDate,2)-1))-7
VAR _pystartDate = DATE(YEAR(_startDate)-1,MONTH(_startDate),DAY(_startDate))
VAR _endDate = _startDate+6
VAR _pyendDate = DATE(YEAR(_endDate)-1,MONTH(_endDate),DAY(_endDate))
RETURN CALCULATE(SUM(Table[Sales]),Table[Date] >= _pystartDate && Table[Date] <= _pyendDate)
I have connected calendar table. So this doesn't work.
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |