Forum Discussion
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
Check this one
https://community.powerbi.com/t5/Desktop/Find-next-value-by-date/td-p/503446
If required change sorting and min/max function.
2 Replies
- AnonymousNot applicableLook forward to a reply from the community on this..
- amitchandakSuper User
Check this one
https://community.powerbi.com/t5/Desktop/Find-next-value-by-date/td-p/503446
If required change sorting and min/max function.