Forum Discussion
Last column value
- 6 years ago
If these are only Feb, then I think it is difficult. But if they are dates then you can do it easily.
There is very powerful function as part of Feb 2020 release that can help - lastnonblankvalue
https://docs.microsoft.com/en-us/dax/lastnonblankvalue-function-dax
lastnonblankvalue(Date,max(Table[Value])
- 6 years ago
Hi matrin ,
If you want to get the last value of a column, you can try the following DAX.
Measure = CALCULATE(LASTNONBLANK('Table'[Column2],1),ALL('Table'))If the problem persists,could you please share sample data or sample .pbix?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi matrin ,
If you want to get the last value of a column, you can try the following DAX.
Measure = CALCULATE(LASTNONBLANK('Table'[Column2],1),ALL('Table'))If the problem persists,could you please share sample data or sample .pbix?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.