Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problems with ISONORAFTER

Im trying to divide the parcels of my products in line and tried to do something like this

the measure ReceivedValue running total... works fine with DocName that the parcels have the same value(A,C) but when there is a value different in the parcel(B,D) things don't work very well. Can someone help me with this?

This is what i expect 

 

Thanks

Power Bi File 

Need Help
Show and Tell
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi Anonymous ,

    you can do it like this (take a look at the attached PBIX file):

     

     

    Running Total = 
CALCULATE (
    [Sum of ReceivedValue],
    FILTER (
        ALLEXCEPT ( Planilha1, Planilha1[OrderId] ),
        Planilha1[DatePayment] <= MAX ( Planilha1[DatePayment] )
    )
)

Sum of ReceivedValue = SUM(Planilha1[ReceivedValue])

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

     

1 Reply

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Anonymous ,

    you can do it like this (take a look at the attached PBIX file):

     

     

    Running Total = 
CALCULATE (
    [Sum of ReceivedValue],
    FILTER (
        ALLEXCEPT ( Planilha1, Planilha1[OrderId] ),
        Planilha1[DatePayment] <= MAX ( Planilha1[DatePayment] )
    )
)

Sum of ReceivedValue = SUM(Planilha1[ReceivedValue])

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)