Forum Discussion

Jpalji's avatar
Jpalji
Frequent Visitor
6 years ago
Solved

How to create line chart by date progression type

Hi,   Please advice I have data as following and to create Progression graph by time. Need to create Progression by date column in Power BI   Thanks in advance.
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Jpaliji, 

    You could try below measure

    Measure 6 =
CALCULATE (
    SUM ( t5[p1] ),
    FILTER ( ALL ( t5 ), t5[date] <= MIN ( t5[date] ) )
)
    + CALCULATE (
        SUM ( t5[p2] ),
        FILTER ( ALL ( t5 ), t5[date] <= MIN ( t5[date] ) )
    )

    Best Regards,
    Zoe Zhi

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

dax's avatar
dax
Community Support
6 years ago

Hi Jpaliji, 

You could try below measure

Measure 6 =
CALCULATE (
    SUM ( t5[p1] ),
    FILTER ( ALL ( t5 ), t5[date] <= MIN ( t5[date] ) )
)
    + CALCULATE (
        SUM ( t5[p2] ),
        FILTER ( ALL ( t5 ), t5[date] <= MIN ( t5[date] ) )
    )

Best Regards,
Zoe Zhi

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

Jpalji's avatar
Jpalji
Frequent Visitor
6 years ago

Hi dax,

 

Thanks for the help, I need to get Progress 1 from a different table.

I will figure it out. and write logic. Once again thanks.

 

:)