Forum Discussion

maart666's avatar
maart666
Icon for Helper I rankHelper I
4 years ago
Solved

Running total for two measures

Hi, I have a table with two dates "Plan Date" and "Act Date" that I need to compare in one line chart. I have to compare them between reports from different dates ("Report date") . I also have a tab...
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi maart666 

    Thanks for reaching out to us.

    you can try this measure,

    RT Plan Date Test = 
CALCULATE(
    COUNTROWS(Arkusz1),
   
    FILTER(
        ALLSELECTED(Arkusz1),Arkusz1[Plan Date] <=MAX('Calendar'[Date])
    )
)

    if this doesn't help, could you provide the expected outcome (how to calculate it, the math formula)? Thanks.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi maart666 

Thanks for reaching out to us.

you can try this measure,

RT Plan Date Test = 
CALCULATE(
    COUNTROWS(Arkusz1),
   
    FILTER(
        ALLSELECTED(Arkusz1),Arkusz1[Plan Date] <=MAX('Calendar'[Date])
    )
)

if this doesn't help, could you provide the expected outcome (how to calculate it, the math formula)? Thanks.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • maart666's avatar
    maart666
    Icon for Helper I rankHelper I
    4 years ago

    Thank you.

    It is what I was looking for!

     

    Marcin