Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello everyone, i have a sample table like this picture:
I'll describe the table columns:
I have a problem, whenever i use TOTALYTD DAX for yearly_running_sum and TOTALMTD DAX for sales_running_sum. The sum is exponentially large, what i want is when i choose February 10, 2024 it'd show 40 for sales_running_sum and 144 for yearly_running_sum. Is there any implementation to get result that i want?
The dates column act as a slicer
the visual slicer
January
February
March
Solved! Go to Solution.
Hi,
I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.
Sales MTD: =
VAR _t =
FILTER (
ADDCOLUMNS (
ALL ( 'date'[date], 'date'[Year], 'date'[Month], 'date'[Day] ),
"@sales", [Sales:]
),
'date'[Year] = MAX ( 'date'[Year] )
&& 'date'[Month] = MAX ( 'date'[Month] )
&& 'date'[date] <= MAX ( 'date'[date] )
)
RETURN
SUMX ( _t, [@sales] )
Sales YTD: =
VAR _t =
FILTER (
ADDCOLUMNS (
ALL ( 'date'[date], 'date'[Year], 'date'[Month], 'date'[Day] ),
"@sales", [Sales:]
),
'date'[Year] = MAX ( 'date'[Year] )
&& 'date'[date] <= MAX ( 'date'[date] )
)
RETURN
SUMX ( _t, [@sales] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.
Sales MTD: =
VAR _t =
FILTER (
ADDCOLUMNS (
ALL ( 'date'[date], 'date'[Year], 'date'[Month], 'date'[Day] ),
"@sales", [Sales:]
),
'date'[Year] = MAX ( 'date'[Year] )
&& 'date'[Month] = MAX ( 'date'[Month] )
&& 'date'[date] <= MAX ( 'date'[date] )
)
RETURN
SUMX ( _t, [@sales] )
Sales YTD: =
VAR _t =
FILTER (
ADDCOLUMNS (
ALL ( 'date'[date], 'date'[Year], 'date'[Month], 'date'[Day] ),
"@sales", [Sales:]
),
'date'[Year] = MAX ( 'date'[Year] )
&& 'date'[date] <= MAX ( 'date'[date] )
)
RETURN
SUMX ( _t, [@sales] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
11 | |
11 | |
10 |
User | Count |
---|---|
31 | |
25 | |
15 | |
13 | |
12 |