Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
4 years ago

Formula between 2 columns

Happy Weekend   Quick question. I have the USD column per month and I created a colum called "Risk". Now I want to create a formula   Risk% = (DIVIDE('Weekly Slippage'[Risk], 'Weekly Slippage'[U...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  romovaro ,

According to the picture shows:

Your [Risk%] shows a calculated column, can you express it with Measure:

Measure =
DIVIDE(
    [Risk],MAX('Weekly Slippage'[USD]))

Result：

Excuse me, are there any other columns in another table besides the Weekly Slippage table.

If I have misunderstood your meaning, please provide your pbix without privacy information and desired output.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • romovaro's avatar
    romovaro
    Responsive Resident
    4 years ago

    HI Liu Yang

     

    I only use one table. no other tables included in the formulas

    Tried your measure but still not working...weird... provides a diff % but that's not the one I need.

     

    USD column provides USD for all the years (FY23, FY24, FY25...) i just need to use from July 2022 to June 2023.