Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm not exactly sure how to ask the question - but I know what I'm trying to accomplish -
I have a list of customers. I've calculated how old the customer is already and placed that value (in days) in a column called 'Age of Customer'.
Here's the measure I need to create:
if the customer age is <= 365 - the commission rate is 5%
if the customer age is >= 366 - the commission rate is the changed to 3%
I can write out the algorithm, but I'm very new to DAX and not sure how to do this. ANY help in the right direction would be greatly appreciated!!
Thanks so much! 🙂
Solved! Go to Solution.
It seems as if you need a calculated column and not a measure.
Commission = IF([Age of Customer] <= 365, .05, .03)
It seems as if you need a calculated column and not a measure.
Commission = IF([Age of Customer] <= 365, .05, .03)
Thank you so much!!! This worked like a charm! 🙂