Forum Discussion

EmmaDilemma's avatar
EmmaDilemma
New Member
3 years ago
Solved

How do I type this excel formula into Powerquery in Powerbi

Hi clever people,   I need to transfere this simple excel formula into a custom column in Powerquery in Powerbi .  (J cell is Departure Date, I cell is Cover Start Date,BG cell is Month of Earning...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    So IF statements are written slightly different "if" "then" "else"  and you dont need to define a SUM like you do in Excel so try this...

     

    if ([Departure Date] < [Month of Earning] then 0.2 else ([Month of Earning] - [Departure Date]) / ([Departure Date] - [Cover Start])

     

    Let me know if that works for you.

     

    Thanks,

Anonymous's avatar
Anonymous
Not applicable
3 years ago

So IF statements are written slightly different "if" "then" "else"  and you dont need to define a SUM like you do in Excel so try this...

 

if ([Departure Date] < [Month of Earning] then 0.2 else ([Month of Earning] - [Departure Date]) / ([Departure Date] - [Cover Start])

 

Let me know if that works for you.

 

Thanks,