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.
'* 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] )
Go to Solution.
Hi @jwi1 ,
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.
Proud to be a Super User!
View solution in original post
Good day @MFelix ,
Thanks fo your nmessage. I was already able to solve this isssue bij myself over the last weekend.
So, problem solved!
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.