Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm looking to create a LASTNONBLANK measure for a column in a table visual. It works fine, but if the user moves the 'date between' slicer min(date) to beyond when the lastnonblank was logged it goes blank.
I need the max(date) in the date slice to still effect to LASTNONBLANK measure. Is there some way to have the date table that the LASTNONBLANK measure scans over ignore the min(date) slicer values for the page?
@gwyn I'm not quite sure what you're trying to acheive, but the ALL() function returns an entire table and you need a single scalar value. Dax.Guide is a great resource for what each function does.
Try using MINX for your start time:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thank you, If i could send you a beer virtually I would.
@gwyn Best reply ever - much thanks. Did you solve your problem then or still have more questions?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
All Sorted, I was clearly just trying to jam the whole (ALL(T_DATE) table into the DATESBETWEEN function where it wanted the MINX date value. I have successfully worked around the lower part of the slicer. 🍻