Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Cumulative data on a period

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 th...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

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.