Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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] )
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] )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |