How to set parameters on a measure for the current month and day but in the previous year
Hello Forum, I am having an extremely hard time figuring out how to get the desired results from a measure. Below you see my DAX measure: Cumulative Sales Volume Previous Year = CALCULATE( [Cumulative Sales Volume], SAMEPERIODLASTYEAR(v_Dim_Time[Date]), v_Dim_Time[Date] <= TODAY() ) Although, this measure mostly works, it does not only show the completed days from this year in the previous period...rather the entire month/year in the previous period. I want to do a direct day to day comparison and I cannot figure how to constrain the results.
With Power BI report server May 2022 how to call a Stored Procedure with Parameter via URL
I have a report published on-premise server. Data source mode is import. Stored procedure has custom parameters in report. From my UI I call the URL where report is published but user want to pass parameter value and refresh the data source with those parameter value. How would I do that? How do I pass parameter value in URL and refresh the data or call the SP = Sql.Database(ServerName, DBName, [Query="exec [dbo].[MY_SP] '" & Parm1 & "','" & Parm2 & "'"])
Dynamic Parameter not updating
Hello, I have a simple report using a dynamic parameter with DirectQuery that works locally on Power BI Desktop for RS, and also works on the Power BI Service with gateway. On the report server, when I change the bound parameter on the slicer, the table looks like it's updating, and the logs show the new parameter is set, but the data does not update and continues to use the initial parameter value set. I have updated to January 2023. Are there plans to fix?
