Add if statement to VAR

[assemomar]

Kindly, if you could help me add an if statement in below VAR, 

If the statement is like this: if (AssetMaintenanceRequests[Month]) = "JAN," then VAR (as below)

Regard,,

VolumeJAN =

var Color = AssetMaintenanceRequests[Month]

var CarModel = CALCULATE(MAX('VOLUME-JAN'[volume]),AssetMaintenanceRequests[Month]= Color)

return CarModel

[_AAndrade · Accepted solution]

Hi @assemomar,

Please try if this solve your problem:

VolumeJAN =

var Color = SELECTEDVALUE(AssetMaintenanceRequests[Month])

var CarModel = CALCULATE(MAX('VOLUME-JAN'[volume]),AssetMaintenanceRequests[Month]= Color)

return 
IF(Color = "JAN," CarModel )

[v-yilong-msft · Accepted solution]

Hi @assemomar ,

Your solution is great, @_AAndrade . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I think we can use the IF function to check if the Color variable (which holds the month from AssetMaintenanceRequests[Month]) equals "JAN". If it does, we proceed with your original calculation to determine CarModel. If not, the function returns BLANK(), meaning no value will be returned for months other than January.

Here is the DAX I will provide.

VolumeJAN =
VAR Color = AssetMaintenanceRequests[Month]
RETURN
    IF (
        Color = "JAN",
        VAR CarModel =
            CALCULATE (
                MAX ( 'VOLUME-JAN'[volume] ),
                AssetMaintenanceRequests[Month] = Color
            )
        RETURN
            CarModel,
        BLANK ()
    )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[_AAndrade · Accepted solution]

Hi @assemomar,

Please try if this solve your problem:

VolumeJAN =

var Color = SELECTEDVALUE(AssetMaintenanceRequests[Month])

var CarModel = CALCULATE(MAX('VOLUME-JAN'[volume]),AssetMaintenanceRequests[Month]= Color)

return 
IF(Color = "JAN," CarModel )