Forum Discussion

dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver I
2 years ago
Solved

% Colomn

Dear colleagues; As per the picture below i would like to have "% of Realisation" Please could you help me with DAX mesure that i can use?  Thank you  
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, dofrancis3 

    make new column

    %palnned = 
DIVIDE('Table'[realisation],'Table'[planned])

     

     

    make new column

    %realisation = 
1-('Table'[%palnned])

     

    and change them to percantage