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 need to add all the amounts of the orders in previous months to the first week of the selected month (in the slicer).
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous ,
I have created sample for your reference.
Measure = var sle = MIN('Table'[Date])
var pre = CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Date]< sle))
return
pre+ CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[week] = MIN('Table'[week])))
Pbix as attached.
Hi @Anonymous ,
I have created sample for your reference.
Measure = var sle = MIN('Table'[Date])
var pre = CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Date]< sle))
return
pre+ CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[week] = MIN('Table'[week])))
Pbix as attached.
Hi @Anonymous ,
It is always a good practice to post a sample data to get a better and faster response.
The formula below is just based on your description and it assumes that the first week ends at the seventh of the month and there is not separate dates table.
Running Count =
VAR FirstWeek =
EOMONTH ( MAX ( Table[Date] ), -1 ) + 7
RETURN
CALCULATE ( [Amount], FILTER ( ALL ( Table[Date] ), Table[Date] <= FirstWeek ) )
Proud to be a Super User!
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |