Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Nevermind. Got it! 🙂
@jendefig 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! 🙂
@jendefig 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |