Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Need help with the dax

I need help with a dax, the dax at present is  YOY Sales Growth details % = if([To Year Sales]>0,DIVIDE([To Year Sales]-[Sales Amount],[Sales Amount])*100)   If, from YTD is blank % should ...
Need Help
  • VijayP's avatar
    VijayP
    4 years ago

    Avivek 

    IF(isblank(from Ytd),"100"%, if(isblank(to ytd),"-100",DIVIDE([To Year Sales]-[Sales Amount],[Sales Amount])*100)
    Try this!

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Avivek Try this:

YOY Sales Growth details % =
Var result_ = if([To Year Sales]>0,DIVIDE([To Year Sales]-[Sales Amount],[Sales Amount])*100)
RETURN SWITCH(TRUE(),
                             [From YTD]=BLANK(), 100,

                              [To YTD]=BLANK(),-100,
                              result_
                          )