How to use a user input date serial number in another calculated column
Hi! I wanted to let the user to input a date and do a column calculation based on that date. To achieve this, I added a parameter slicer, where the user input number would be the serial number of the target date, as we are only allowed to input a whole/decimal number but not a date as a parameter. The parameter table was Base Date, the series column was Date (Serial Number), and the selected value was captured in Base Date Value. Base Date Value = SELECTEDVALUE('Base Date'[Date (Serial Number)]) However, when I used Base Date Value in calculation of a column, the calculation seemed not working: Here, I want to compute, under each contract, the total spend amount of invoices whose Final Approval Month (which is a date in fact) is within the 365 days before the BASE DATE selected by user. I calculate the difference between the serial number of the approval date and the input serial number and compare it with 0 and 365. Basically, the calculation gives me a blank column. Just for testing purpose, if I use TODAY() as the base date and compute the column as followed, it works and gives me some values. How can I use the Best Date Value in the calculation of the column to achieve my goal here?
