Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

IF with measure

Hi all   I am trying to create an if measure like this:   IF( HASONEVALUE(facilities[bottler])="ABI El Salvador", CALCULATE( [Complaints], 'date'[MM YYYY]=DATE(2020,11,1)...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this measure

    =

    IF(SELECTEDVALUE(facilities[bottler])="ABI El Salvador",CALCULATE([Complaints],
    DATESBETWEEN('date'[date],date(year(min('date'[date]))-1,11,1),date(year(min('date'[date]))-1,12,31))),CALCULATE([Complaints],PREVIOUSYEAR('date'[date])))
o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago

Awsome Ashish_Mathur 

 

Thanks a million all of you, have a great weekend.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.