Need help with a DAX formula that looks at a field's value and adjusts the calculation accordingly.

[krichmond]

Table Name = mv_perfex

I have a DAX field called "90 Day Date Designator" that assigns a true / false indicator based on a "Start Date" field. This works.

• 90 Day Date Designator = IF(DATEDIFF(mv_perfex[startdate],TODAY(),DAY)<=90,"True","False")

I now need help creating a DAX field that leverages the "90 Day Date Designator" and does the following

1. If the "90 Day Date Designator" field equals "True" than multiply the "Projected Paid Responders" and the value of "Projected Premium" multiplied by "Projected Paid Responders".
   
2. If the "90 Day Date Designator" field equals "False" than multiply the "Paid Responders @100%" and the value of "Actual Premium" multiplied by "Actual Paid Responders".

Sample data can be found here: https://www.dropbox.com/s/jc9jzftpmzi7j2c/Sample%20Data%20For%20Community%20Post.csv?dl=0

[v-zhangti · Accepted solution]

Hi, @krichmond 

The data you provide is a bit confusing. I've briefly simulated a few to hopefully match your situation.

Column:

90 Day Date Designator = IF(DATEDIFF(mv_perfex[startdate],TODAY(),DAY)<=90,"True","False")

Column = SWITCH(TRUE(),
[90 Day Date Designator]="True",[Projected Premium]*[Projected Paid Responders],
[90 Day Date Designator]="False",[Actual Premium]*[Paid Responders @100%]*[Actual Paid Responders])

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.