Fill in blanks with last non blank value (using DAX measure)

[Anonymous]

hi everyone,

How can i create the following logic?

[ThomasCo]

Table was bad to read.

[ThomasCo]

Date                   Value      Categros
01.01.2020          1             a
....

[ThomasCo]

DateValueCategory

01.01.2020	1	a
01.01.2021	2	a
01.01.2022	3	a
01.01.2023	4	a
01.01.2020	10	b
01.02.2021	20	b
01.03.2022	30	b
01.04.2023	40	b

[ThomasCo]

Hi,

I have a problem with a similar topic. But in my case I have only values for category when I have also a Value. But I still want to have a tabel who have entries for each day 1st of Jan, 2nd of Jan, ... with the las value to get a time series with the SUM by category. For all Dates in the Calendar table that reachts until end of 2023.

01.01.2020	1	a
01.01.2021	2	a
01.01.2022	3	a
01.01.2023	4	a
01.01.2020	10	b
01.02.2021	20	b
01.03.2022	30	b
01.04.2023	40	b

Have you any idea?

[CNENFRNL · Accepted solution]

[Anonymous]

@Nathaniel_C