Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Can you tell me more why this formula work ? Why use min function ?
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.
User | Count |
---|---|
101 | |
69 | |
58 | |
47 | |
47 |