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!
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!