Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a problem with Power BI,
I use a table like this
1/01 1
1/01 1
2/01 1
5/01 -1
And I want to make a cumulate value like this
1/01 2
2/01 3
5/01 2
I use this DAX function
But when I use the date slicer, for exemple focus on 3/03 and 16/03 , i have this
I want that when i use date slicer, the data focus on the date selected but not affect the values. How can i do this ?
Thank you in advance
Solved! Go to Solution.
Hi @nr63bi ,
Please try below steps:
1. below is my test table
Table:
Date:
Date = CALENDAR(FIRSTDATE('Table'[Date]),LASTDATE('Table'[Date]))
Model:
2. create a measure with below dax formula
Measure =
VAR cur_date =
SELECTEDVALUE ( 'Table'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), [Date] <= cur_date )
RETURN
SUMX ( tmp, [Value] )
3. add a table visual with Table field and measure, add a slicer visual with Date table field
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @nr63bi ,
Please try below steps:
1. below is my test table
Table:
Date:
Date = CALENDAR(FIRSTDATE('Table'[Date]),LASTDATE('Table'[Date]))
Model:
2. create a measure with below dax formula
Measure =
VAR cur_date =
SELECTEDVALUE ( 'Table'[Date] )
VAR tmp =
FILTER ( ALL ( 'Table' ), [Date] <= cur_date )
RETURN
SUMX ( tmp, [Value] )
3. add a table visual with Table field and measure, add a slicer visual with Date table field
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You do that by using a disconnected table to feed your slicer.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
110 | |
109 | |
73 | |
71 |