Forum Discussion

jkdt33's avatar
jkdt33
New Member
2 years ago

How to add a date parameter column to a query

I am trying to be able to create a parameter that adds a 'X' # of days to a date for accounting. But the problem is that I run into is that I need to then be able to connect this new date to my date ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jkdt33 ,

Below is my table:

The following DAX might work for you:

X days after due date = 
    var dat = SELECTEDVALUE('Table'[Due_Date])
    return
       dat+'Days after due date'[Days after due date Value]

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jkdt33's avatar
jkdt33
New Member
2 years ago

Ill try to re explain my needs better to better understand the entirety of what I am looking for and needing. 

 

I have 2 total tables. An accounting fact table and a Date table. 

 

Accounting Fact Table 

- I have a column that has a outstanding balance 

- I have a Colmn that has the original Due_Date for that balance 

- My Task is i need to have a variable/parameter day to be able to change how many ('X') days is past the original due date. So we want to know when is 90 days, 150 days, 200 days, etc. past the due date

- I need to have this 'Variable Date' to be in a column so that I can use this column to be my relationship date with my Date Table 

 

- I need to create my visuals based on the Date of the variable date column.