Forum Discussion
Execute stored procedure with user parameters
Hi All, I am still trying to learn the nuances of Power BI as I am from a SSRS background. I am trying to achieve the following in Power BI. The user should have an option to select a dat...
Seward12533
Solution Sage
Solution SageWhy not bring in all the data associate with a Data Table and then just use filters to control what is displayed? I use PowerBI with hundreds of thousdans of records.
Hi Seward12533,
I can bring all data into the datatable but it is not static. Based on the selected date, the calculations will change. So I can't bring all the data into the datatable in one shot.
Another way is to consider all the dates for the past 2 years, and calculate for each date and insert into a table and bring that table's contents over to the datatable. The amount of data would be huge.
I personally believe that this is not an apt solution. But if nothing works, i will do this itself.
Thanks,
Vijeth