cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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 screenshot1.PNG

 

Hope i get a solution:)

Thanks in advacne!

2 REPLIES 2
Super User II
Super User II

Hi @Nageshshastry1

 

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   

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.

 

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors