Need to calculate UCL, LCL values for the previous 3 dates from "from date".

[Aradhana]

Hi All,

Below graph shows UCL and LCL values for the dates selected in the slicer. But the actual requirement is, need to show these values for previous 3 dates from "from date" in slicer and user can select any date as from and to date from DB. As per the below graph 6th April 2023 is from date and I need to calculate UCL,LCL for 3rd,4th and 5th April Diameter values.

I thought of passing "from date"  as a parameter value to either stored procedure or function in Postgres database to calculate UCL,LCL.  But we can use dynamic parameters only in powerbi desktop not in service as per most of the blogs.

In the below blog, they are showing how can we use SQL SP with dynamic parameters in powerbi service with some settings in SQL server and Powerbi.

https://www.youtube.com/watch?v=N1En6_NB_dY

But not sure, How can we achieve the same using postgre SQL.

Do you think Is there any other work around for my calculation.

Thanks in advance.

Thanks,

Har**bleep**ha

[lbendlin]

As long as your data source is accessed in Direct Query mode you can use dynamic query parameters.

For your scenario you need to use a secondary, disconnected calendar table.