cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Time Intelegence

I have an array of data where Value can only be in two states 1 or 0. Each value has its own timestamp of the event change from 1 to 0, etc.

When i build line chart PowerBI return me this:

What i need:

What measure i need to write to get red grapfic? Table of time already have.

1 ACCEPTED SOLUTION
Helper I

@yingyinr PBI freezes too with this measure:(

I tried to use a different construction, now everything is fine. Ty for help!

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

7 REPLIES 7
Super User IV

@Bessonnizza1992 , Under shape, Switch on Stepped.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helper I

Ty for reply, but this option don't help me.

For example i have two points

Value 1 - Timestamp 00:00:00

Value 0 - Timestamp 00:21:37

So mesuare must calculate all points beetween this.

Value 1 - Timestamp 00:00:01

Value 1 - Timestamp 00:00:02

Value 1 - Timestamp 00:00:03

Value 1 - Timestamp 00:00:04

and so on.

Community Support

What's your desired result? According to your example data, whether the table is what you want:

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

@yingyinr , thank you for reply!

Yes, this table is exactly what i need. I managed to write a measure that fill down values, but CalendarTime table have 86400 row, and when i try to add measure in values (line chart) PBI is freze.

As a result i want to buid this chart:

I have an idea with another measure. I don't need to fill in all the lines, need only get the value of the previous non blank line and substitute it into the (current line index - 1). Mb you know how can i do it?

Here my example https://dropmefiles.com/vH1NG

Best regards!

Community Support

I updated your sample pbix file, please check whether that is what you want. I create a measure  as below to get the values:

``````Measure =
VAR _curtime =
MAX ( 'CalendarTime'[Time] )
VAR _curvalue =
CALCULATE (
MAX ( 'Statistics'[Value] ),
FILTER ( 'Statistics', 'Statistics'[Timestamp] = _curtime )
)
VAR _pretime =
CALCULATE (
MAX ( 'Statistics'[Timestamp] ),
FILTER (
ALL ( 'Statistics' ),
'Statistics'[Timestamp] < _curtime
)
)
VAR _prevalue =
CALCULATE (
MAX ( 'Statistics'[Value] ),
FILTER ( ALL ( 'Statistics' ), 'Statistics'[Timestamp] = _pretime )
)
RETURN
IF ( ISBLANK ( _curvalue ), _prevalue, _curvalue )``````

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

@yingyinr PBI freezes too with this measure:(

I tried to use a different construction, now everything is fine. Ty for help!

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

Community Support

It's glad to hear that your problem has been resolved. And thanks for sharing your solution for us. Thank you.

Best Regards

Rena

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

## Helpful resources

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!

#### Check it Out!

Click here to read more about the December 2020 Updates!

#### Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

#### Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors