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 All,
I wish to calculate sales for 6 months and this should exclude sales from Jan. This should also be dynamic ie in August we should exclude Jan and Feb.
Heres the formula I've used but its not worked
Year-Mon | 6mth Total Sales (Desired) | 6mth Total Sales (current output) |
23-Jan | $1,265.18 | |
23-Feb | $1,576.41 | $1,576.41 |
23-Mar | $836.15 | $836.15 |
23-Apr | $2,888.95 | $2,888.95 |
23-May | $893.56 | $893.56 |
23-Jun | $2,075.89 | $2,075.89 |
23-Jul | $222.60 | $222.60 |
Solved! Go to Solution.
@mm456 Try this
6 Month Sales =
VAR _result =
SUMX (
KEEPFILTERS (
DATESINPERIOD (
CalendarDate[Date],
TODAY (),
-6,
MONTH
)
),
[Total Sales]
)
RETURN
_result
@mm456 Try this
6 Month Sales =
VAR _result =
SUMX (
KEEPFILTERS (
DATESINPERIOD (
CalendarDate[Date],
TODAY (),
-6,
MONTH
)
),
[Total Sales]
)
RETURN
_result
hI @mm456 ,
Try the following formula:-
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
53 | |
46 | |
16 | |
12 |