Set paramaeter's Default value to the Start of month

[cmkrishnaprasad]

So i am developing a report where i've set two parameters to filter the dates,

From_date and To_date.

To_date default Value is Today(), for From_date i want to set the default value from the Starting day of the current month.

I tried using this Expression

But i am getting this error.

"The 'Value' expression for the report parameter 'From_date' contains an error: [BC30108] 'Date' is a type and cannot be used as an expression.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing."

Is there any other way that i can do this?

[ray_codex · Accepted solution]

Date is a DAX function, you are building this in the Power BI report builder, right? The internal expression language isn't DAX. You can check the common function to see how to write expressions, see the arrow. This will work, might be a little different depending on your region:

[cmkrishnaprasad]

Hey @ray_codex, That worked for me

Thanks..!🤝

[some_bih]

Hi @cmkrishnaprasad based on picture, you selected Constants as Category. Check it.