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

Using Latest Value on dates where value is blank

I'm struggling to create a measure that shows the latest value of item while there was no date value.

 

To give an example:

Przechwytywanie.JPG

I am expecting to have a table like this :

Przechwytywanie2.JPG

so while there is no value in fact table I would like to take the latest value under specific item and use it.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Using Latest Value on dates where value is blank

@mhsk ,

 

So in the table visual you provided, when the [FactTableDate] is blank then take the latest [part] and [Quantity]? So why the 111 and 5 are the latest value in 03.01.2019? Could you clarify the logic?

 

Regards,

Jimmy Tao

Highlighted
Helper I
Helper I

Re: Using Latest Value on dates where value is blank

it is correct, i'm looking for the latest value (Quantity) while there is no value (FactTableDate) for each of Part 

 

so for part 111 the 03.01.2019 was empty so i wanted to use latest value for this part and it is 5 ,  for 04.01.2019 it is the same. Once new value is provided lets say 06.01.2019 for value 111 there is new Quantity = 6 i would like to have 6  units under this item ,until new value for this item arise in table.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors