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
kincaids's avatar
kincaids
Helper II
7 years ago

d_gosbell,

 

It's definitely closer to what I'm expecting to see. I'm sure it's still off, though, because of the payoff issue.

 

I think I found a date for rental payoffs. I imported another table, "sctrans", which is the Transactions table. Here's the information from that table I think you need:

 

Table Name: sctrans

Date Column: Gen Ledger Date

Column for types of Transactions: Transaction Type

Targeted Transaction Type: Contract Payoff

 

If you're able to add that into the code, it may do the trick. Thanks again for taking the time to help me figure this out - I greatly appreciate it!

 

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.