cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

pull values ​​down

Hello all!

 

How to pull values ​​down, need measure, not PQ.

 

Bessonnizza1992_0-1601733227545.png

 

10 REPLIES 10

Hi @Bessonnizza1992,

My formula is included iterator calculation, if you are handling huge amount of records, it may reduce the performance.

>>Can you explain me how can i filtered this rows? Only the current line (with original value) and previous line needs to be left. 

I'm not so clear about your requirement, can you please explain more about this? Did you mean the expression should end the calculate if they executed to the end of your fact table records?
If this is a case, you can add an if statement to package this expression to prevent the calculation on not existed date range:

Measure =
VAR _lastDate =
    MAXX ( ALLSELECTED ( Statistics ), [Timestamp] )
VAR currDate =
    MAX ( CalendarTime[Time] )
VAR prev =
    CALCULATE (
        MAX ( Statistics[Timestamp] ),
        FILTER ( ALLSELECTED ( Statistics ), [Timestamp] <= currDate )
    )
RETURN
    IF (
        currDate <= _lastDate,
        CALCULATE (
            MAX ( Statistics[Value] ),
            FILTER ( ALLSELECTED ( Statistics ), [Timestamp] = prev )
        )
    )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors