Forum Discussion
Complex transaction calculation via User controlled date range
Hi All, I have a problem that I'm unable to solve in PBI. We have used Sisense, where we write SQL queries and pass user input dynamically and use it in where filter clause and case statements. ...
You are welcome. Go to the Query Editor and review the steps in the Applied steps pane. Yes, the file size will increase but i do not know of a better way to solve this.
Ashish_Mathur Thank you for your time! I see that you have selected all the dates between start date and end date and put it in a new column. How did you do that transformation? Also, will this not increase the size of the table as we grow in data? Currenty we have 50K contractors.
You are welcome. Go to the Query Editor and review the steps in the Applied steps pane. Yes, the file size will increase but i do not know of a better way to solve this.