Fill up missing values

[Anonymous]

Hi all,

I have created a new table, which gives me the maximum value of a partnr_creditor per year - month.

Looking at the partnumber_sup 008873J (example), I want to fill up the values for the months, which do have no values:

first look for the most recent value;

if not, look for the first-nex value

The outcome should be as follows:

Month 1 and 2: show value of month 3 (show first next value)

Month 6, 7 and 8: show value of month 5 (smost recent value)

Month 9: show value of month 8 (show most recent value)

Hope you can help me with this, thanks in advance.

John

test_tabel = 
        SUMMARIZE (
            '* werkblad',
            '* werkblad'[partnr_creditor] ,
            '* werkblad'[invoice_date] ,
            '* werkblad'[invoice_date_jaar] ,
            '* werkblad'[invoice_date_maand] ,
            "part.price.list", LASTNONBLANKVALUE ( '* werkblad'[partnr_creditor], MAX ( '* werkblad'[part.price_list] ) 
)) 

 

[MFelix · Accepted solution]

Hi @Anonymous ,

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Anonymous]

Good day @MFelix ,

Thanks fo your nmessage. I was already able to solve this isssue bij myself over the last weekend.

So, problem solved!

John