Forum Discussion

kincaids's avatar
kincaids
Helper II
9 years ago

Seemingly simple date issue...

My company rents band & orchestra instruments to school children.  I have a handful of data query tables and I've created a calendar table.   For this issue, I think all I need to focus on are thes...
Need Help
d_gosbell's avatar
d_gosbell
Super User
7 years ago

I would not suggest solving this by changing the existing DAX to make it more complicated. I would suggest changing the query to look up the pay off date and insert it into the Return Date column (or make a new derived column if you like that combines the return date and payoff date). Then we just have to remove the filter excluding the X records and everything should just work.

kincaids's avatar
kincaids
Helper II
7 years ago

d_gosbell,

 

That makes complete sense. Unfortunately, I'm not sure how to create the new column when the dates for returns are on one table ('scrental') and the dates of the payoffs are on another ('sctrans'). I've been trying to research it to no avail.