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.
I created a calculated colum with the following code:
PRESSA GUESS = LASTNONBLANKVALUE(Merge3[Merge2.cp01.frman], MIN(Merge3[Merge2.cp01.frman]))
Which is not working
I would like to make it return for the same (item - on the right) the earlier value in chronogical terms when it's blank.
Any suggestion?
Expected output is like the present calculated column but with value 31 loaded on it.
Thank you.
Solved! Go to Solution.
@marcoproserpio , Try a new column as
var _max= maxx(filter(Merge3, Merge3[items.nbr] =earlier(Merge3[items.nbr])),Merge3[Dates])
return
maxx(filter(Merge3, Merge3[items.nbr] =earlier(Merge3[items.nbr]) && Merge3[Dates]=_max ),Merge3[PRESSA_GUESSA])
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |