Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

how to hide Future dates

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!

Need Help

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.