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!

     

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
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!

 

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

Wow, VijayP , thankyou, i was tryig similar measure but now I can see what was the mistake i made. Thankyou for your help.