count taking into account date conditions

[Anonymous]

Hi all,

Here is my problem:

I would like to calculate de YTD number of incidentes solved in time or out of date, following the conditions explained bellow:

Table:

[Incident]

[Date of entry]

[Date of resolution]

[Expiration Date]

If [Data of resolution] = null -> then -> IF[expiration Date] > the date in the filter context (for example FY 2010 and April seleted in the slicer) -> Then "In Time", else "Out of Date"

But

If [Data of resolution] = is not null -> then IF[expiration Date]> [Data of resolution] -> Then "In Time", else "Out of Date"

Attached you can find the link to the pbx file 

Thank you so much for your help

Rbn

[Greg_Deckler]

Sorry, not entirely clear on this. But perhaps a variation of Open Tickets? https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

[Anonymous]

Thanks @Greg_Deckler for the tip

Sorry if I have not been clear, english is not my first language, and sometimes is not easy to put in words in a clear way  all my thoughs.

Basically what I want to do is a custom column with "met" or "missed" values, based on if the "expiration date" is greater than the "date of resolution". The problem is when the "date of resolution" is null. In this case I want to compare with the date last date ot the month filtered with the slicer. For example, in the second line that I have an error, and asumming that in the slicer I have selected March 2020, I would likte to compare  31/03/2020 with 15/05/2020 and return a "Met" value.

In the line 4 on the contrary I would compare 31/03/2020 with 15/03/2020 and return "Missed"

Thank you very much

[Greg_Deckler · Accepted solution]

Well, if you need this to be interactive based on a slicer, then you cannot code a column in Power Query or as a DAX calculated column, because columns are calculated at the time of data load and are thus not dynamic based upon user interaction.

What you need is a measure and if you need to comparie "previous" rows, you will need to use something like EARLIER. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...