topic Set paramaeter's Default value to the Start of month in DAX Commands and Tips

Set paramaeter's Default value to the Start of month

cmkrishnaprasad — Tue, 05 Dec 2023 13:51:05 GMT

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?

Re: Set paramaeter's Default value to the Start of month

some_bih — Tue, 05 Dec 2023 15:24:42 GMT

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

Re: Set paramaeter's Default value to the Start of month

ray_codex — Tue, 05 Dec 2023 15:59:14 GMT

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:

Re: Set paramaeter's Default value to the Start of month

cmkrishnaprasad — Wed, 06 Dec 2023 07:09:21 GMT

Hey ray_codex, That worked for me

Thanks..!🤝