What If Parameter - how to use in a calculated column?

[AlexChampion]

Hi All,

In my PBI report, I have a table "dash_Monthly_7E" which looks like this:

The calculated column "Month Start Date" has the following formula:

The "As At Date" object is a What-If Parameter that the user can define when viewing the report.

I need the table to update the dates in column "Month Start Date" when a date value is entered into the What-If Parameter.

This currently isn't working, and the EOMONTH function is using today's date, instead of the value in the parameter.

I have read that this is because What-If Parameters cannot be used in calculate columns, which "Month Start Date" is.

So I think I understand the problem, does anyone know any workarounds please?

Thank you. 

[AlexChampion · Accepted solution]

I have managed to resolve this issue.

I simply recreated the table "dash_Monthly_7E" and replaced all of the calculated columns with measures. The measures are able to  use the What-If parameter in their DAX code and so it works now.