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!
Solved! Go to Solution.
Hi @webportal ,
You can create a calculated column as below:
Coluna =
CALCULATE (
LASTNONBLANK ( 'Tabela'[Class], MAX ( 'Tabela'[Data] ) ),
ALL ( 'Tabela' )
)
Best Regards
Hi @webportal ,
You can create a calculated column as below:
Coluna =
CALCULATE (
LASTNONBLANK ( 'Tabela'[Class], MAX ( 'Tabela'[Data] ) ),
ALL ( 'Tabela' )
)
Best Regards
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
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
User | Count |
---|---|
388 | |
216 | |
84 | |
72 | |
69 |
User | Count |
---|---|
447 | |
247 | |
136 | |
82 | |
78 |