Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
7 years ago
Solved

Dax IF OR BLANK

 

Hi I need Help with the following Formula:

 

Promotion Q3 = IF(MAX('Resource Forecast Q3'[Level Type])<>MAX('Resource Actual'[Level Type]),"YES",BLANK())
 
I want to add to this formula to ONLY consider those lines that has same "NAME" Between my 2 queries:
'Resource Forecast Q3'[Name]  & 'Resource Actual'[Name]
 
 
I tried someting like this but it has an error:
 
Promotion Q3 = IF(MAX('Resource Actual'[Name]=MAX('Resource Forecast Q3'[Name])),IF(MAX('Resource Forecast Q3'[Level Type])<>MAX('Resource Actual'[Level Type]),"YES",BLANK()),"")
 
Could you help me?
Thanks.
Need Help
Tips and Tricks

2 Replies

  • cristianml's avatar
    cristianml
    Post Prodigy
    7 years ago

    hi,

     

    Also I tried something like this but it has an error too:

     

    Promotion Q3 = IF(AND((MAX('Resource Actual'[Name])=MAX('Resource Forecast Q3'[Name])),IF(MAX('Resource Forecast Q3'[Level Type])<>MAX('Resource Actual'[Level Type]),"YES",BLANK())),IF(MAX('Resource Forecast Q3'[Level Type])<>MAX('Resource Actual'[Level Type]),"YES",BLANK()),"")
     
    Thanks.