Forum Discussion

CamillaDiPassio's avatar
CamillaDiPassio
Frequent Visitor
4 years ago

Progressive substraction in chart

Hello everyone, 

I have a problem with the creation of a chart.

The data I have are as follows:

- Part number = a set of unique code

- Created Date= date of creation of the code

- Modified Date = date of modified of the code 

- Outcome= the code is active or not (True/False)

 

I have to create a waterfall chart where I have by month the active codes minus the subtraction of those no longer active in that month (using the modified date). 

 

I got the following chart using these formulas:

- controllo = if(AND(Registry[ToControl]=false, Registry[Created].[Date]<>Registry[Modified]),1,0)    --> creation of a new column with a binary output

- Quanti meno = -(DISTINCTCOUNT(Registry[PartNumber])-sum(Registry[controllo]))  --> creation of a measure by month

 

 

But in this chart I can't insert the progressive substraction, so I would to see by month the earlier number of code minus the code that are no longer active. Any suggestion?

Thank you!

 

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
    Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
    Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

    https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • CamillaDiPassio's avatar
    CamillaDiPassio
    Frequent Visitor
    4 years ago

    Hi,

    I insert an example of data.

     

    CreatedPartNumberOutcomeModified
    28/03/2022 10:45A1801TRUE29/03/2022 05:57
    28/03/2022 10:45A1802TRUE29/03/2022 05:58
    28/03/2022 10:45A1803TRUE29/03/2022 06:04
    28/03/2022 11:36A1804TRUE29/03/2022 06:23
    28/03/2022 11:38A1810TRUE29/03/2022 06:22
    28/03/2022 11:38A1811TRUE29/03/2022 06:22
    28/03/2022 11:38A1812TRUE29/03/2022 06:22
    28/03/2022 11:38A1813TRUE29/03/2022 06:22
    28/03/2022 14:23A1814FALSE28/03/2022 14:23
    28/03/2022 14:24A1815FALSE28/03/2022 14:24
    28/03/2022 10:38A1816FALSE08/07/2022 07:57
    28/03/2022 10:38A1817FALSE08/07/2022 07:57
    28/03/2022 10:38A1818FALSE08/07/2022 07:57
    28/03/2022 10:39A1819FALSE08/07/2022 07:57
    28/03/2022 10:39A1820FALSE07/07/2022 09:48
    28/03/2022 10:39A1821FALSE07/07/2022 09:48
    28/03/2022 10:44A1822FALSE27/05/2022 08:18
    28/03/2022 11:37A1823FALSE08/07/2022 07:50
    28/03/2022 11:38A1824FALSE08/07/2022 07:50
    28/03/2022 11:39A1825FALSE08/07/2022 07:50
    28/03/2022 10:34A1842TRUE28/03/2022 10:34
    28/03/2022 10:34A1843TRUE28/03/2022 10:34
    28/03/2022 10:34A1844TRUE28/03/2022 10:34
    28/03/2022 10:34A1845TRUE28/03/2022 10:34
    28/03/2022 10:34A1846TRUE28/03/2022 10:34
    28/03/2022 10:34A1847TRUE28/03/2022 10:34
    28/03/2022 10:35A1848TRUE28/03/2022 10:35
    28/03/2022 10:35A1849TRUE28/03/2022 10:35
    28/03/2022 11:42A1850TRUE28/03/2022 11:42
    28/03/2022 11:43A1851TRUE28/03/2022 11:43
    28/03/2022 14:34A1852FALSE28/03/2022 14:34
    28/03/2022 14:34A1853FALSE28/03/2022 14:34
    28/03/2022 14:34A1854FALSE28/03/2022 14:34
    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Please indicate the expected outcome. Is this it?

       


      Also note that the seed value (the starting value) is in the same month as some of the reductions - that cannot be shown in the waterfall chart unless you go down to day level.