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
Actually, that seems to have lost the "last non-blank" functionality. It now shows the most recent entry for the column but if there is no entry for todays date for that item, instead of displaying yesterday's entry, it just displays the blank.
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!