Forum Discussion

ingpiolo's avatar
ingpiolo
Frequent Visitor
3 years ago

calculation using Previous value empty

Hi everyone, I have a table like this:   I should calculate subsequent fields as indicated iteratively by associating a measure (Filled fields are final values while empty ones are an estima...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ingpiolo ,

I created a sample pbix file(see the attachment), please find the details in it.

Result = 
VAR _seldate =
    SELECTEDVALUE ( 'Table'[Date] )
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALLSELECTED ( 'Table' ), [Sum of value] > 0 )
    )
VAR _value =
    SUMX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] = _maxdate ),
        [Sum of value]
    )
VAR _measures =
    CALCULATE (
        SUM ( 'Table'[Measure] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= _seldate )
    )
RETURN
    IF (
        ISBLANK ( SELECTEDVALUE ( 'Table'[Measure] ) ),
        BLANK (),
        _value + _measures
    )

Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ingpiolo ,

    It seems that I have no access to your shared file, could you please grant me the proper permisson to it? Thank you.

    Best Regards

    • ingpiolo's avatar
      ingpiolo
      Frequent Visitor
      2 years ago

      Ok, I should have unlocked access. you can check?

      Thank you