next available date after today

Annemie19 · ‎09-29-2020

Hi There,

I have the following table below.

I want to only see the first 'measurementnextdate' after the measurementDate in the slider.

For instance, if today is 29/09/2020. then it should only show items for 01/11/2020 for the specific Covenant ID, there are more than one different Covenant ID's.

Can someone please help me with a measure for this

stevedep · ‎09-29-2020

Hi,

Can you share some data?

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Kind regards, Steve.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article

My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!

Annemie19 · ‎09-29-2020

Hi Steve,

Its is not allowing me to upload a table.

This is what I tried...

AA Next MDate =

VAR FirstMeasurementDate = [AA First MDate]

VAR DatesGreaterThanValueDate =

FILTER (

SUMMARIZE (VwCovenant,VwCovenant[Measurementnextdate], VwCovenant[CovenantID]),

VwCovenant[Measurementnextdate] > FirstMeasurementDate

)

VAR NextImmediateDate =

MINX ( DatesGreaterThanValueDate, VwCovenant[Measurementnextdate] )

RETURN

NextImmediateDate

But it is returning this, which is not correct as I only want it to show the first row.

Annemie19 · ‎09-29-2020