Conditional Calclated column help

---

Anonymous wrote:

Hello,

First post here.  Tried to find answer, but no luck.  I have a column labeled "Frequency" with entries of "Every Month"  "Every two weeks" and "Every week."  In addtion I have a revenue column named "Amount".

 

What I want to do is create a column for "Expected Monthly Revenue" where:

 

Expected Monthly Revenue = If Frequency = Every Month, then = Amount,

                                                If Frequency = Every two weeks, then = 2*Amount,

                                                If Frequency = Every week, then = 52*Amount/12

 

I have tried in the Query Editor with Conditional column, but couldn't put a formula for result.

 

Then I've tried with calculated column, but can't find the right DAX syntax to get down to the specific entries in "Frequency" column.

Many thanks in advance

 

---