Conditional Calclated column help

[Anonymous]

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

[Anonymous · Accepted solution]

Nevermind.  Got it! 🙂

Expected Monthly Revenue = IF(Table1[Frequency]="Every Month", Table1[Amount],IF(Table1[Frequency] = "Every 2 weeks",(26*Table1[Amount]/12),IF(Table1[Frequency] = "On the 1st & 15th",(2*Table1[Amount]),IF(Table1[Frequency] = "Every week", (52*Table1[Amount]/52)))))

---

@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

---