Using a date slicer to define FIRSTNONBLANK and LASTNONBLANK values leads to problems

[I_LOVE_POWER_BI]

Hi community,

What I do now and doesn't fully work:

I am using a date slicer on my report choosing 2 dates. Via FIRSTNONBLANK and LASTNONBLANK the values in one matrix are shown via the 2 measures based on the chosen dates (Last Planning / Current Planning). However, for some dates there aren't any entries on LASTNONBLANK (Current Planning) - that way it will show the same value as in FIRSTNONBLANK (Last Planning). But I want to exactly see the value for that date, if there is no value, I want it to show 0 for that date.

I guess that's just what FIRSTNONBLANK and LASTNONBLANK is intended to do.

What I need now:

So now I am looking for an option how to dynamically use my date slicer and show the first chosen date in one measure and the second chosen date in another measure. However, I can't come up with anything better than the mentioned example above. And no, I do not want to write "hard" lookups into the measure beacuse I would completly loose the flexibility via the slicer.  

Looking forward to your ideas! Thanks!

[Anonymous]

Hi @I_LOVE_POWER_BI ,

Did above formula works for you? If it works please consider to mark it as solution. If not, please share some sample data and expected result to us.

Best Regards,

Jay

[amitchandak]

@I_LOVE_POWER_BI , not very clear

max date in slicer =maxx(allselcted(date),date[date])

min date in slicer =minx(allselcted(date),date[date])