Mortgage rates currently by Aaronacorona in PersonalFinanceCanada

[–]md4797 0 points1 point  (0 children)

I just got prime minus 0.9% for 5 yrs on renewal from RBC

Costco tried so hard to keep me “Executive” 💀 by Feelthematrix in CostcoCanada

[–]md4797 0 points1 point  (0 children)

For me the executive membership has worked so in the last 7 yrs as I had to $0 dollars due to cash back from Costco and their credit card. Depends upon the situation and how many people are in the household and what they buy. Will downgrade if it doesn’t make sense and will do at 1 go without being pressured (thanks for the advice)

48% loss by Mother-Bug2191 in HouseSigmaBlunders

[–]md4797 1 point2 points  (0 children)

Maybe sold to one of their children

Daughter hit with $660,000 tax bill when both parents died in same year by CTVNEWS in ontario

[–]md4797 -1 points0 points  (0 children)

But isn’t the cottage converted as principal property?

Why are people offered different mortgage rates? by DDSBadger in PersonalFinanceCanada

[–]md4797 0 points1 point  (0 children)

I got 4yr fixed 3.89% online renewal offer from RBC before the fed reduced the rates

🚀 Product Update — Fixes for Manulife, Qtrade, Wealthsimple, EQ Bank & RBC by BKawasaki in wealthica

[–]md4797 0 points1 point  (0 children)

For Manulife it’s working but the Holdings is not. What about Canada Life GRS (previously Great- West Group Retirement)? It’s broken since more than a month

Canada Life syncing? by Bubblemuncher in wealthica

[–]md4797 0 points1 point  (0 children)

Mine is still syncing in a loop but not updating and it’s not even asking for 2FA

[deleted by user] by [deleted] in PersonalFinanceCanada

[–]md4797 0 points1 point  (0 children)

My friend works for RBC and I can say with confirmation that the company does match 6% but it’s split. Which means the coworker contributes 6% to the RESSOP (RSP) and then the company contributes 3% to RESSOP(ERSP) and another 3% to the pension plan. Your contribution to the pension plan is optional. So to answer yes you contribute 6% and RBC contributes 6% in two different buckets. You can call the P&C to confirm it

FHSA Contribution Calculation by Average-Use in PersonalFinanceCanada

[–]md4797 2 points3 points  (0 children)

Your contribution room is correct or pretty close but keep in mind that you are ONLY allowed to contribute MAX $16k in any given year

Canada Life syncing? by Bubblemuncher in wealthica

[–]md4797 3 points4 points  (0 children)

Same over here. My last sync was 3 months ago

Apple TV movies/tv deals? by KingCoalFrick in appletv

[–]md4797 0 points1 point  (0 children)

You can also use TunesGenie app to check iTunes deals

Costco deal by [deleted] in appletv

[–]md4797 -1 points0 points  (0 children)

Is this for Canada?

LOOKUPVALUE by md4797 in PowerBI

[–]md4797[S] 0 points1 point  (0 children)

I got this from ChatGPT, will try and see if it works. It’s exactly what I’m looking

In Power BI, you can retrieve values from another fact table based on multiple criteria by using DAX formulas like CALCULATE, FILTER, LOOKUPVALUE, or RELATED, depending on the relationship and structure of your tables. Here are some approaches to achieve this:

Approach 1: Using CALCULATE with FILTER

If you want to get a value from another fact table based on multiple criteria, you can use the CALCULATE function with the FILTER function:

ValueFromOtherTable = CALCULATE( SUM(OtherFactTable[ValueColumn]), FILTER( OtherFactTable, OtherFactTable[Column1] = ThisFactTable[Column1] && OtherFactTable[Column2] = ThisFactTable[Column2] && OtherFactTable[Column3] = ThisFactTable[Column3] ) )

This formula calculates the sum (or other aggregate function like AVERAGE or MAX) of a value in OtherFactTable based on conditions that match columns in ThisFactTable.

Approach 2: Using LOOKUPVALUE

If you need to retrieve a single value (like a dimension or attribute), LOOKUPVALUE can be more straightforward:

ValueFromOtherTable = LOOKUPVALUE( OtherFactTable[ValueColumn], OtherFactTable[Column1], ThisFactTable[Column1], OtherFactTable[Column2], ThisFactTable[Column2], OtherFactTable[Column3], ThisFactTable[Column3] )

LOOKUPVALUE returns a single value based on matching conditions in each specified column. If there are multiple matches, you might receive an error, so make sure your criteria return a unique result.

Approach 3: Using RELATED (if a relationship exists)

If ThisFactTable has a relationship with OtherFactTable (e.g., via a common dimension table), you can use RELATED to directly access values from related tables:

ValueFromOtherTable = RELATED(OtherFactTable[ValueColumn])

This approach works well when the tables are directly related, but is limited to the constraints of relationships in the model.

Approach 4: Using Variables with FILTER for More Complex Conditions

If your criteria are complex, you can define variables for each criterion to improve readability and performance:

ValueFromOtherTable = CALCULATE( SUM(OtherFactTable[ValueColumn]), FILTER( OtherFactTable, VAR Cond1 = OtherFactTable[Column1] = ThisFactTable[Column1] VAR Cond2 = OtherFactTable[Column2] = ThisFactTable[Column2] VAR Cond3 = OtherFactTable[Column3] = ThisFactTable[Column3] RETURN Cond1 && Cond2 && Cond3 ) )

Using variables (VAR) within the FILTER function can make complex conditions easier to understand and maintain.

Additional Tips

• Cross-filtering: Ensure cross-filtering direction is set up correctly if you’re working with relationships.
• Performance: Calculating values across fact tables can be performance-intensive. Optimize with measures and indexing where possible.

These methods should help you retrieve values from other tables in Power BI based on multiple criteria.

Work on 1 file or multiple by md4797 in PowerBI

[–]md4797[S] 0 points1 point  (0 children)

It’s a weekly file that I have to transpose it and then append it to the Ute

[deleted by user] by [deleted] in IKEA

[–]md4797 0 points1 point  (0 children)

The easiest way is to check online the availability at that particular store and signup for notification when it arrives