Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Performing Fill Up using DAX

Dear all,

 

First of all, thanks for taking the time to read my post. I am quite new to DAX/Power BI and thus really appreciate the help:

 

I like some help to find out if its possible to write a DAX to perform "Up fill"; I would like to use value from a later timestamp to fill in blank fields from in a column:

 

Using this same question as an example, does anyone knows how I can do up filling instead?

 

Meaning from the column with datetime and value as below:

                   Datetime       Value              

1. 01/01/2017, 2:00 AM - 500

2. 01/01/2017, 2:30 AM - blank

3. 01/01/2017, 4:00 AM - 850

4. 01/01/2017, 6:00 AM - 600

 

 I need:

                   Datetime       Value              

1. 01/01/2017, 2:00 AM - 500

2. 01/01/2017, 2:30 AM - 850

3. 01/01/2017, 4:00 AM - 850

4. 01/01/2017, 6:00 AM - 600

 

i.e. I need to replace the "blank" value at 01/01/2017, 2:30 AM with the value at 01/01/2017, 4:00 AM.

 

Blanks like the above happens through several spots in my column, hence I need to write a DAX for this. I know that the above can be done via the Fill function in the Power Query editor but I can't really run query all the time as my data source is a secured SQL server which I can only connect to at specific locations.

 

BTW I saw the DAX written for Fill Down i.e. replace the 01/01/2017, 2:30 AM with the value at 01/01/2017, 2:00 AM instead

 

https://community.powerbi.com/t5/Desktop/Dax-fill-down-in-formula/td-p/318991

 

Not sure if the DAX in this thread can be written to Fill Up instead, thanks!

 

Regards,

AY80