Show latest value for missing rows

[fajlix]

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 Modified	Store	Area	Revenue	Period
2023-01-01	S1	A1	10	202301
2023-01-01	S2	A2	20	202301
2023-01-01	S3	A2	30	202301
2023-02-02	S1	A1	15	202301
2023-02-02	S3	A2	35	202301
2023-03-03	S1	A1	0	202301
2023-03-03	S2	A2	25	202301
2023-01-01	S1	A1	11	202302
2023-01-01	S2	A2	21	202302
2023-01-01	S3	A2	31	202302
2023-02-02	S1	A1	16	202302
2023-02-02	S3	A2	36	202302
2023-03-03	S1	A1	1	202302
2023-03-03	S2	A2	26	202302
2023-01-01	S1	A1	12	202303
2023-01-01	S2	A2	22	202303
2023-01-01	S3	A2	33	202303
2023-02-02	S1	A1	17	202303
2023-02-02	S3	A2	37	202303
2023-03-03	S1	A1	2	202303
2023-03-03	S2	A2	27	202303

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:

How could I solve

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

Hope this helps.

[fajlix]

Does anyone have any ideas about this?