Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] )
))
Solved! 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsGood day @MFelix ,
Thanks fo your nmessage. I was already able to solve this isssue bij myself over the last weekend.
So, problem solved!
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |