Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am very new to power bi and dax, so I thought I start with a simple dax formula.....and failed
I have a table with
year, month,value
I created a slicer with "month"to select"
I want to measures
1. sum of values of selected month
2. sum of values where month <= selected month
Month is a numeric field, so not a date field.
First calculation is simple but second value gives the same result as 1.
This is my formula:
Cumulative_value = sumx(filter(table, table[month] <= selectedvalue(table[month]))tabel[values])
What am I doing wrong ?
Solved! Go to Solution.
Hi @newtopbitoo
Cumulative_value =
VAR aux_ =
SELECTEDVALUE ( table1[month] )
RETURN
SUMX ( FILTER ( ALL ( table1 ), table1[month] <= aux_ ), table1[values] )
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Or alternatively:
Cumulative_value =
VAR aux_ =
SELECTEDVALUE ( table1[month] )
RETURN
CALCULATE ( SUM ( table1[values] ), table1[month] <= aux_ )
It would be better to have dates rather than two separate columns with year and month. That will not work if your data spans more than one year
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi @newtopbitoo
Cumulative_value =
VAR aux_ =
SELECTEDVALUE ( table1[month] )
RETURN
SUMX ( FILTER ( ALL ( table1 ), table1[month] <= aux_ ), table1[values] )
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
18 | |
14 | |
14 |