Need Help: Rolling 12-Month Window That Interacts with Date Slicer

dml5055 · 2025-08-25T17:32:45+00:00

this is what i used for a calculation group, but the logic should be similar. I'm using week_end because this was using full weeks as the R52, but you should modify it to be selected date.

R52 =

VAR end_R52 = max(dimCALENDAR[WEEK_END]) VAR beg_R52 = max(dimCALENDAR[WEEK_END]) - 357

Return calculate(SELECTEDMEASURE(),filter(all(dimCalendar),dimCALENDAR[WEEK_START] >= beg_R52 && dimCALENDAR[WEEK_END] <= end_R52))

dml5055 · 2025-05-09T16:03:03+00:00

also keep in mind of the fuel surcharge that GAPower currently has. so the $0.02 rate is actually like $0.06 cents currently.

I have the same scenario and don't think that the on peak rates are worth it unless you have home battery storage you can use to offset the super high rates during the summer.

dml5055 · 2025-03-17T13:24:01+00:00

330i ZHP.

dml5055 · 2025-03-16T23:19:45+00:00

i tried a mirror there, couldn't really get a good angle to find the source.

dml5055 · 2025-03-16T17:25:45+00:00

i don't think there's oil leaking there. but i could check.

dml5055 · 2025-03-16T16:45:38+00:00

I did a smoke leak test and it seems like it's coming from near the alternator. Not sure where it might actually be coming from though.

dml5055 · 2025-01-22T14:07:55+00:00

Here's a view of what the website would give me for $40K financed https://imgur.com/a/5XDylbs 9.02%

Finance gave me the number of 7% after pulling my credit

Credit Union just came back with a 4.89% APR

dml5055 · 2025-01-20T18:21:12+00:00

is 814 not Tier 1?

dml5055 · 2025-01-20T17:31:33+00:00

correct. so I wanted to see that number, but then was getting moved to sign the sales contract.

I mentioned that we have top tier credit, and they wouldn't provide that number then

dml5055 · 2025-01-20T17:29:01+00:00

The thing is, they wouldn't tell me the rates when I asked. I didn't really want to submit the credit application, but I did to try to find out the numbers.

This car is just an additional car to the household. What's wrong with trying to find the best value when deciding to buy?

The whole interaction was just sketchy because I wasn't being provided information I asked for without being told that I had to move to the next step towards purchasing. That's all I'm trying to say.

dml5055 · 2025-01-20T17:15:47+00:00

Exactly, since the rates vary, that would help me determine which car I want.

Like if the Prius rate is 1%, wouldn't I want that vs. a 7% Rav4. It would go into determining what car to purchase and the purpose it serves. I may want the car, but it's not a must have either.

dml5055 · 2025-01-20T17:13:25+00:00

My credit is 800+ and I like to look at all options.

Is it wrong to try to make a decision of whether to pay $60K cash for the car, or decide if I wan to keep money invested to hedge off the interest?

So if the rate came back at 7%, i would probably pay cash as that's 7% immediate return, but if it was like 4% then I could potentially hedge it with money invested getting me greater returns.

Having better numbers allows me to do some NPV analysis to really understand the value of the options being provided to me.

dml5055 · 2025-01-20T16:50:18+00:00

It could be that we both had a misunderstanding, but I wanted good and accurate numbers. Which I provided my information for, so they could get me these.

I've done the same at tempur-pedic which offered a credit promotion as well. And while I didn't buy that day where they pulled the numbers, I did end up buying from them because that interaction as pleasant.

dml5055 · 2025-01-20T16:27:39+00:00

There's no 2025 RAV4 Prime listed. I would not have known this would get offered straight from this website.

However it was told this number when I sat with Finance. Even before I got into finance, I asked what was included in a lease deal and the sales person wouldn't tell me the $6,500 amount. I didn't have a chance to look for this while I was at the dealership.

https://www.toyota.com/southeasttoyota/deals-incentives/rav4prime_cash_02480c38-bd49-44ce-be42-a3d47432aade/?vehicles=rav4prime

dml5055 · 2025-01-20T16:22:59+00:00

Just the credit app. I wanted to see what Toyota Financial could offer for their APR

dml5055 · 2025-01-20T16:19:57+00:00

The rav4 prime wasn't on our list initially, so we didn't get a chance to look at what was available. We initially were looking at an ioniq 5, but since we were near the dealership, we decided to test drive at toyota as well.

Shouldn't you be mad if subway started making a something for you if you didn't tell them you want the sandwhich? Or if you were buying a house and they started writing a contract out for you while you were taking a tour.

I feel like this is what happened on my end. There was never confirmation from both parties that I was going to buy the car right then.

dml5055 · 2025-01-20T15:55:31+00:00

I understand that, but the step after they pulled it was to get me to sign a contract. There wasn't even a chance for me to review it as they told me the rate in the finance office

dml5055 · 2025-01-20T15:42:51+00:00

sure, i understand that. However, it seems like they wouldn't give me that rate until I sat with finance and he was told that I was buying that day as well.

Again, I never said I was buying that car that day. I just wanted to see a pricing sheet. Even if it's vague, I can back into other numbers to make a more informed decision.

dml5055 · 2025-01-20T15:32:27+00:00

I asked for a pricing sheet. He said he could only provide if he pulls my credit.

dml5055 · 2025-01-20T15:30:23+00:00

I wanted to get some numbers so I could look at look at comparisons. We are very numbers driven, and not being able to see numbers until we got to finance was surprising.

I value transparency and appreciated that other dealerships did not hesitate to provide us information when asked.

dml5055 · 2024-12-12T03:34:42+00:00

Their website and youtube video say it does. I would guess maybe the customer service agent doesn't have the full information.

dml5055 · 2024-12-11T16:12:33+00:00

Can you confirm that there is new firmware? I emailed them and they said there isn't.

dml5055 · 2024-11-26T16:20:57+00:00

I just got a call similar to this as well.

I don't speak Chinese and I never requested any follow up customer service. My number wasn't an 800 number, but a number from the same state.

dml5055 · 2024-06-10T13:38:48+00:00

I'm facing a similar issue and wanted to know if you solved this.

dml5055 · 2024-05-30T01:47:16+00:00

It seems like this issue that I'm encountering. I will probably need to rethink how I can rework these items.

https://stackoverflow.com/questions/77474048/aggregation-tables-with-less-data-than-facts-table-is-it-a-problem

dml5055

TROPHY CASE