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 want to build a table to compare the cumulative sales of the current month to the sales of last month. The problem is when I calculate de sales from last month my table shows only the values based on the day of the current month. For example, this month I have sales from day 1 to day 17, which is right. But form the last month I what to show the cumulative sales from day 1 to day 30 and not until day 17 as below.
Thanks in advance!!
Solved! Go to Solution.
@Anonymous , Try like
Last MTD QTY forced=
var _max1 = maxx(allselected('Date')'Date'[Date])
var _max = date(year(_max1),month(_max1)-1,day(_max1))
return
CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
@Anonymous , Try like
Last MTD QTY forced=
var _max1 = maxx(allselected('Date')'Date'[Date])
var _max = date(year(_max1),month(_max1)-1,day(_max1))
return
CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |