Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DAX formula optimization question

Hi All,   I’m trying to implement a DAX column calculation in order to determine if a person is 100% non-billable or partial billable. I have a column in a table which states the ‘Today’s commitmen...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

    Are you experiencing performance issues with your current formula? How large is the table where you want to create the new column?

    Another way to create the desired column could be to try:

     

    VIP Calculation = Switch(True();

                                           Candidate[Todays_commitment_rate__c] = 0 ;"100% VIP"; 
                                           Candidate[Todays_commitment_rate__c] < 100 ;"Partial VIP";
                                           Blank()
                                     )

     

    Try and see if the performance is improved.

     

    BR,

    Magnus

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

Are you experiencing performance issues with your current formula? How large is the table where you want to create the new column?

Another way to create the desired column could be to try:

 

VIP Calculation = Switch(True();

                                       Candidate[Todays_commitment_rate__c] = 0 ;"100% VIP"; 
                                       Candidate[Todays_commitment_rate__c] < 100 ;"Partial VIP";
                                       Blank()
                                 )

 

Try and see if the performance is improved.

 

BR,

Magnus

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Magnus,

 

Thank you very much, the performance increased by adding the Switch functionality to the equation. 

 

Greetings,

Ronald