Forum Discussion

kincaids's avatar
kincaids
Icon for Helper II rankHelper 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
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi kincaids,

Sorrr for inconvenience, I update the reply, please verify and feel free to ask if you have any question.

Best Regards,
Angelia

kincaids's avatar
kincaids
Icon for Helper II rankHelper II
7 years ago

Well, things have changed - it took a couple years for me to get around to it, but I'm working on rebuilding my data, and this is still an issue. Again, I'm trying to get a line graph that shows how many current rentals we have at any given time over the past 6 years (and into the future). This is what it looks like right now:

 

Todays current rentals show up across all time, rather than the actual current rental count each moment in timecalendar DAX based on the same table the current rentals are taken fromcurrent parameters of the visualization in question

 

Your help in figuring out why it's showing today's current rental number across all time rather than what the current rental number actually was at each point in time would be greatly appreciated.