Forum Discussion
babyjb1979
Helper I
Helper IFill up gaps with duplicate date
Hi Power Bi Gurus, I have a table with date and value, I am using the DAX code to fill up the gaps as following: New Value = VAR LastNonBlankDate = CALCULATE ( FIRSTNONBLANK ( Ta...
Hi babyjb1979 ,
Here are the steps you can follow：
1. Create measure.
Measure = IF( MAX('Table'[Value]) =BLANK(), MINX( FILTER(ALL('Table'), 'Table'[ID]=MAX('Table'[ID])&&'Table'[Date]>MAX('Table'[Date])&&'Table'[Value]<>BLANK()),[Value]), MAX('Table'[Value]))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi babyjb1979 ,
Here are the steps you can follow：
1. Create measure.
Measure =
IF(
MAX('Table'[Value]) =BLANK(),
MINX(
FILTER(ALL('Table'),
'Table'[ID]=MAX('Table'[ID])&&'Table'[Date]>MAX('Table'[Date])&&'Table'[Value]<>BLANK()),[Value]),
MAX('Table'[Value]))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
babyjb1979Helper I
Helper IAnonymous
The logic appears to be correct, but please check that the data is still incorrect. Please use the new data to test. Thank you very much for your time and help!!!
| ||
| ID | Date | Value |
| 1023201 | 9/1/2023 0:00 | |
| 1023201 | 9/2/2023 0:00 | |
| 1023201 | 9/3/2023 0:00 | |
| 1023201 | 9/4/2023 0:00 | |
| 1023201 | 9/5/2023 0:00 | |
| 1023201 | 9/6/2023 0:00 | |
| 1023201 | 9/7/2023 0:00 | |
| 1023201 | 9/8/2023 0:00 | |
| 1023201 | 9/9/2023 0:00 | |
| 1023201 | 9/10/2023 0:00 | |
| 1023201 | 9/11/2023 0:00 | |
| 1023201 | 9/12/2023 0:00 | 12 |
| 1023201 | 9/26/2023 0:00 | |
| 1023201 | 9/27/2023 0:00 | |
| 1023201 | 9/28/2023 0:00 | |
| 1023201 | 9/29/2023 0:00 | |
| 1023201 | 9/30/2023 0:00 | |
| 1023201 | 10/1/2023 0:00 | |
| 1023201 | 10/2/2023 0:00 | 7 |
| 221934 | 9/1/2023 0:00 | |
| 221934 | 9/2/2023 0:00 | |
| 221934 | 9/3/2023 0:00 | |
| 221934 | 9/4/2023 0:00 | |
| 221934 | 9/5/2023 0:00 | 5 |
| 221934 | 9/11/2023 0:00 | |
| 221934 | 9/12/2023 0:00 | |
| 221934 | 9/13/2023 0:00 | |
| 221934 | 9/14/2023 0:00 | |
| 221934 | 9/15/2023 0:00 | |
| 221934 | 9/16/2023 0:00 | |
| 221934 | 9/17/2023 0:00 | |
| 221934 | 9/18/2023 0:00 | |
| 221934 | 9/19/2023 0:00 | |
| 221934 | 9/20/2023 0:00 | |
| 221934 | 9/21/2023 0:00 | |
| 221934 | 9/22/2023 0:00 | |
| 221934 | 9/23/2023 0:00 | |
| 221934 | 9/24/2023 0:00 | |
| 221934 | 9/25/2023 0:00 | |
| 221934 | 9/26/2023 0:00 | 16 |
| 246075 | 9/1/2023 0:00 | |
| 246075 | 9/2/2023 0:00 | |
| 246075 | 9/3/2023 0:00 | |
| 246075 | 9/4/2023 0:00 | |
| 246075 | 9/5/2023 0:00 | |
| 246075 | 9/6/2023 0:00 | |
| 246075 | 9/7/2023 0:00 | |
| 246075 | 9/8/2023 0:00 | |
| 246075 | 9/9/2023 0:00 | |
| 246075 | 9/10/2023 0:00 | |
| 246075 | 9/11/2023 0:00 | |
| 246075 | 9/12/2023 0:00 | |
| 246075 | 9/13/2023 0:00 | |
| 246075 | 9/14/2023 0:00 | 14 |
| 246075 | 9/27/2023 0:00 | |
| 246075 | 9/28/2023 0:00 | |
| 246075 | 9/29/2023 0:00 | |
| 246075 | 9/30/2023 0:00 | |
| 246075 | 10/1/2023 0:00 | |
| 246075 | 10/2/2023 0:00 | |
| 246075 | 10/3/2023 0:00 | 7 |