Time with if statments is too long

[dorian_paoli06]

Hi every one, i would like to know if it is possible to simplify my code.

The time spent is way too long and i don't know any alternative to do the same thing but way faster with less if statments. 

My code : 

var test =

IF(FIRSTDATE('calendar BVE validés'[Date]) <= FIRSTDATE('Calendar enregistrements'[Date]),

IF(FIRSTDATE('calendar BVE uploadés'[Date]) <= FIRSTDATE('Calendar enregistrements'[Date]),

IF(FIRSTDATE('calendar tickets validés'[Date]) <= FIRSTDATE('Calendar enregistrements'[Date]),

IF(FIRSTDATE('calendar tickets uploadés'[Date]) <= FIRSTDATE('Calendar enregistrements'[Date]),

IF(FIRSTDATE('calendar validation'[Date]) <= FIRSTDATE('Calendar enregistrements'[Date]),

IF(FIRSTDATE('calendar 1ere connexion'[Date]) <= FIRSTDATE('calendar email'[Date]),

IF(FIRSTDATE('calendar email'[Date]) <= FIRSTDATE('Calendar enregistrements'[Date]),

CALCULATE(distinctcount('PersonValues'[PersonGuid]), FILTER(PersonValues, PersonValues[Type] = -1732183153)),

'Mesure PV'[Emails confirmés]),'Mesure PV'[1ère connexion]), 'Mesure PV'[Profils validés]), 'Mesure CI'[Tickets uploadés]), 'Mesure CI'[Tickets validés]), 'Mesure SV'[Création de bordereaux]), 'Mesure SV'[Validation de bordereaux])

return

IF( MAXX({FIRSTDATE('calendar email'[Date]), FIRSTDATE('calendar 1ere connexion'[Date]), FIRSTDATE('calendar profils complétés'[Date]),FIRSTDATE('calendar validation'[Date]), FIRSTDATE('calendar tickets uploadés'[Date]), FIRSTDATE('calendar tickets validés'[Date]), FIRSTDATE('calendar BVE uploadés'[Date]), FIRSTDATE('calendar BVE validés'[Date])},[VALUE])>Date(2020,12,19),[Emails confirmés], test).

Thank you in advance for the time you will spend on my problem.

[johnt75 · Accepted solution]

There are a few things you can do to clean up the code which will make it easier to read and maintain and also improved performance. 

Instead of using FIRSTDATE use MIN. FIRSTDATE returns a table, MIN returns a scalar value and you are using it as a scalar value.

Retrieve all the min dates only once and store them in variables. Currently you have to calculate each minimum date twice, which will impact on performance.

Rather than using the nested IF statements, which are impossible to read, use the pattern

SWITCH( TRUE(),
    Condition 1, Result 1,
    Condition 2, Result 2,
    Default result
)

You could also store the result of the [Email confirmes] measure in a variable, as you are using that twice as well.