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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
216 | |
54 | |
46 | |
43 | |
41 |
User | Count |
---|---|
277 | |
210 | |
73 | |
73 | |
65 |