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.
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
Solved! Go to Solution.
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.
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.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |