Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
fajlix
Frequent Visitor

Show latest value for missing rows

Hi,

 

I have a table looking something like this, where each entry has the date when the revenue for a specific store during a perticulare period was updated. For clariry, the period is the actual timeframe and the date modified is the date where a person (lets say accountant) actually entered that value. Sometimes the date modified is before the period meaning that it is an estimate for the revenue at that time. 

Date ModifiedStore AreaRevenuePeriod
2023-01-01S1A110202301
2023-01-01S2A220202301
2023-01-01S3A230202301
2023-02-02S1A115202301
2023-02-02S3A235202301
2023-03-03S1A10202301
2023-03-03S2A225202301
2023-01-01S1A111202302
2023-01-01S2A221202302
2023-01-01S3A231202302
2023-02-02S1A116202302
2023-02-02S3A236202302
2023-03-03S1A11202302
2023-03-03S2A226202302
2023-01-01S1A112202303
2023-01-01S2A222202303
2023-01-01S3A233202303
2023-02-02S1A117202303
2023-02-02S3A237202303
2023-03-03S1A12202303
2023-03-03S2A227202303

My problem is that I want to show what the estimation/actual revenue was at a specific date (date modified).

Even though a specific field might not have been updated. For example store S2 was not updated 2023-02-02 however I still want to show the latest value i.e the value from 2023-01-01 giving me something like this:

fajlix_0-1692354188015.png

How could I solve

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

Please find attached the PBI file.

Hope this helps.

Ashish_Mathur_0-1692403935441.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Please find attached the PBI file.

Hope this helps.

Ashish_Mathur_0-1692403935441.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
fajlix
Frequent Visitor

Does anyone have any ideas about this?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.