Forum Discussion
Conditional Calclated column help
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
Nevermind. Got it! :)
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