I want a Column to find the last non blank value from "Class" following the order of the "Date" column.
Thus, the first 3 rows will be empty.
Rows from 31/01/2016 to 30/04/2016 will be A.
And ALL the remaing rows will be B.
I know the following will work:
Thanks for helping!
Go to Solution.
Hi @webportal ,
You can create a calculated column as below：
LASTNONBLANK ( 'Tabela'[Class], MAX ( 'Tabela'[Data] ) ),
ALL ( 'Tabela' )
View solution in original post
Please try this measure expression, replacing T1 with your actual table name.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.