how to hide Future dates

[Anonymous]

Hi Floks,

Hope you are doing good.

I Work for IT service reporting where i need to show how the Incident has impacted throughout the year.

We track the availability of Incidents. If there is no Incident, then it is considered to be 100% accurate.

Below is the formula which I have used.

(IF(SUM(Unav[Weighed unavailability impact (minutes)])=BLANK(),1,1-(SUM(Unav[Weighed unavailability impact (minutes)]))/((COUNT('Apps Region maping'[Application]))*[Day1]*24*60)))

Below is my Query,

 When I am using the above formula, it is showing the future date as well as 100%, How do I show only till the latest month

Below is the screenshot

Hope i get a solution:)

Thanks in advacne!

[AlB]

Hi @Anonymous

Have you tried the visual level filter? You can there filter out anything above March 2019 (on the field that has the date in your model).

Another option would be to embed this in your measure:

NewMeasure =
VAR _Res = [YourCurrentMeasureCode]
VAR _LastDate2Show = EOMONTH ( TODAY (), 0 )
RETURN
    IF ( MAX ( 'Date'[Date] ) <= __LastDate2Show, _Res ) //Return blank if beyond the last date to show   

[Anonymous]

Hi @AlB ,

Thanks for your responce, unforunatly i have given that, if it is blank then give me 100%, so its giving 100% for future data as well.

And also i am not able to do visual filter as its not showing future dates at all in my date table.