Forum Discussion

pro_x's avatar
pro_x
Icon for Helper I rankHelper I
6 years ago

Dax measure

Hi    I have one column, only one column that has rejected and successful. Rejected is represented by 0 and successful is represented by 1. How can I calculate the percentage difference for rejecte...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi pro_x ,

 

What is the final output you want from the sample column shared.

 

Regards,

Harsh Nathani

pro_x's avatar
pro_x
Icon for Helper I rankHelper I
6 years ago

Hi Anonymous 

I want the percentage change

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi pro_x 

     

    % change is difference of old percentage vs new percenatage. Like Sales Last year vs This year

     

    You need to share a good sample of data with the earlier dates,

     

    One column cannot detemine %change when there is no context to that column.

     

    Do you want difference between successful and reject.??

     

    Regards,

    Harsh Nathani

    • pro_x's avatar
      pro_x
      Icon for Helper I rankHelper I
      6 years ago

      Hi Anonymous 

       

      Yes, i want like sales last year vs this year.

      e.g. rejected last year vs this year 

       

      I only have that column with another column for date