Forum Discussion
Return a string with LASTNONBLANK?
Hi n_b_ - try using
LASTNONBLANKVALUE( Calendar[Date], MAX( maintable[Category - Name] ) )
You should then not need the additional FILTER statement.
Hope this helps
David
n_b_ - Can you share your pbix? Scrub any sensitive data you might have. For my simple example I get the correct value. Note the date slicer including the last day that has blanks for its values.
David
Thank you dedelman_clng!
Letting me know that that logic should be working, meant that I could shift my focus to look at how I was implementing it and also at my data. I found that within my data, in the text columns, the the blank rows were blank but they were not null so LASTNONBLANK was not recognising them as truely blank. I did a "replace values" at the Power Query level on these columns to replace [an empty field] with null, and now everything works.
Thank you again for all your help!