Hi @adii ,
To troubleshoot this, consider the following steps:
-
Review the Date Function Usage: Ensure that the function in your DAX query is receiving the correct year, month, and day arguments. The function syntax should be DATE function (DAX) - DAX | Microsoft Learn . Each argument must be an integer, and the resulting date must be within the acceptable date range for Power BI.
-
Check Data Types: Verify that the columns or values you're using as arguments for the function are of the correct data type (i.e., integers for year, month, and day). If you're deriving these values from other columns, ensure those columns are correctly formatted or cast them to integers using the or functions.
-
Validate Date Range: Ensure that the date being generated by the function falls within a valid range. Power BI can handle dates from January 1, 1900, to December 31, 9999. If your calculation might result in dates outside this range, you'll need to adjust your logic.
You can try changing the measure:
...
selected_end_month= EDATE(_las_date,-1)
...
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
