What is the behavior of LASTDATE() vs LASTNONBLANK() in DAX time intelligence calculations?

Power BI Hard

Power BI — Hard

What is the behavior of LASTDATE() vs LASTNONBLANK() in DAX time intelligence calculations?

Key points

  • LASTDATE() is filter context-dependent
  • LASTNONBLANK() prioritizes non-blank values
  • Sparse data can lead to differing results
  • Expression evaluation affects LASTNONBLANK()
  • Filter context influences LASTDATE() results

Ready to go further?

Related questions