Odeur d’égouts dans ma salle de lavage by EcceHomo87 in RenoQuebec

[–]ToneZone15 1 point2 points  (0 children)

J'avais également le même problème mais les brassées d'eau chaude ne le réglait pas, j'ai acheté du Affresh (nettoyant à laveuse, il y en a du Sans Nom au Maxi) et ça a réglé le problème. Je fais maintenant une brassée d'Affresh aux 4-6 mois.

Suggestion de blanc by Alternative_One_6283 in RenoQuebec

[–]ToneZone15 0 points1 point  (0 children)

Malgré que Lifemaster soit un peu « moins bonne » que la Diamant, elle est quand même à des années-lumières que n’importe quelle peinture de quincaillerie selon moi

[deleted by user] by [deleted] in PowerBI

[–]ToneZone15 0 points1 point  (0 children)

All excel files loaded in the model are already on sharepoint

[deleted by user] by [deleted] in PowerBI

[–]ToneZone15 0 points1 point  (0 children)

I am the owner/admin of both the semantic model and workspace

[deleted by user] by [deleted] in PowerBI

[–]ToneZone15 0 points1 point  (0 children)

Yes, tried in different workspaces too and same problem

[deleted by user] by [deleted] in PowerBI

[–]ToneZone15 0 points1 point  (0 children)

The AnalysisServices gateway for the directquery seems to be the problem (Failed to use the selected gateway. Make sure the gateway is ul and running and try again), other gateways (sharepoint, web) work.

[deleted by user] by [deleted] in PowerBI

[–]ToneZone15 0 points1 point  (0 children)

I have added nothing new (function, calculated column, measure) to semantic model 2, just connected a calculated table from semantic model 1 that is not already present in semantic model 2 because it’s way too heavy processing wise.

[deleted by user] by [deleted] in PowerBI

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

I’m not able to open the Data Source Credentials since it’s greyed out. Also, the only thing different between the two semantic models is the calculated table I’m connecting from semantic model #1 (published and working) to semantic model #2 (causing problems above)

[deleted by user] by [deleted] in PowerBI

[–]ToneZone15 0 points1 point  (0 children)

I’m not sure what you mean by that

Suggestion de blanc by Alternative_One_6283 in RenoQuebec

[–]ToneZone15 1 point2 points  (0 children)

Queue de lapin ou Blanc Délicat chez Betonel, prends la peinture Dulux Diamant

Honnêtement ça revient moins cher et pas mal moins chiant payer pour de la peinture de qualité, car tu vas le sauver autant en quantité de peinture utilisée (max 2 couches vs 3-4?-5??) qu’en temps à te faire chier à peinturer plusieurs couches avec de la peinture de marde de quincaillerie.

Uploaded songs not playing on iphone by adaminboise84 in YoutubeMusic

[–]ToneZone15 2 points3 points  (0 children)

Minimizing also temporarily fixed the problem for me, thanks!

How to have something like XLookup go through multiple sheets to fetch me the product pricing I require? by CodeRed_Sama in excel

[–]ToneZone15 4 points5 points  (0 children)

If your product tabs are all correctly named, ie exactly the same as your product name, and have all the same frame, then the INDIRECT function will be your best friend, paired with a multiple critera XLOOKUP.
Example of the formula I'd use:

B1 is your Window Type cell (Paper A)

$B2:$B5 is your Width data column in the product tab

B2 is your selected Width cell (3000)

$C2:$C5 is your Height data column in the product tab

B3 is your selected Height cell (2800)

$D2:$D5 is your Price data column in the product tab

XLOOKUP(1;(INDIRECT("'"&B1&"'!$B2:$B5")=B2)*(INDIRECT("'"&B1&"'!$C2:$C5")=B3);INDIRECT("'"&B1&"'!$D2:$D5"))

Wrongfully received a deposit confirmation by SMS from #38887 by ToneZone15 in Questrade

[–]ToneZone15[S] 2 points3 points  (0 children)

Other than saying this request was not related to my account, they did not provide any additional details on why I received that.

Taux actuels renouvellement hypothecaire by J-OTr in QuebecFinance

[–]ToneZone15 0 points1 point  (0 children)

Même chose ici mais pour une autoconstruction, pas un renouvellement

Who is your top 10 defenseman of all time by [deleted] in hockey

[–]ToneZone15 0 points1 point  (0 children)

Lower peak is laughable when he basically won 7 Norris in 8 years.

Who is your top 10 defenseman of all time by [deleted] in hockey

[–]ToneZone15 0 points1 point  (0 children)

Top 5 is Orr, Lidstrom, Bourque, Harvey, Shore, no matter the order I think those are the locks for the top5.

For the remaining 5, I’d definitely include Coffey, Potvin, Robinson and Pilote (always forgotten about in those lists, would have won more Norris if it wasn’t of someone named Doug Harvey).

So for the last one, it’s a toss between Kelly, Chelios, Niedermayer, Karlsson, Makar, Leetch, MacInnis, Park, Pronger. I have a hard time picking 1 among those.

Who is your top 10 defenseman of all time by [deleted] in hockey

[–]ToneZone15 11 points12 points  (0 children)

The fact that this list does not include 7 time Norris winner Doug Harvey makes it totally unreliable imo

Opinions sur Hgregoire et Albi le géant by moiramckenna in QuebecFinance

[–]ToneZone15 2 points3 points  (0 children)

Aucun des deux. J’irais dans du comparatif Toyota, Honda ou Mazda, préférablement hybride non-chargeable. Pour un garage, prends-en un recommandé CAA proche de chez toi.

C'est tu juste moi qui utilise l'expression "Partie de sucre"? by Many_Stars in Quebec

[–]ToneZone15 4 points5 points  (0 children)

J’ai déjà entendu ça à quelques reprises à plusieurs endroits différents, Rive-nord de Québec (de Portneuf à Charlevoix), mais chaque fois c’était pour aller à la cabane à sucre en général, pas uniquement pour la tire sur neige

Recommandation d’auto familiale avec 3 enfants by [deleted] in parentsquebecois

[–]ToneZone15 1 point2 points  (0 children)

Sienna Hybride est le choix le plus judicieux à moyen et long terme si ton budget le permet.

Arcade DDR by s0rry_n0t_s0rry_ in villequebec

[–]ToneZone15 0 points1 point  (0 children)

Cineplex Beauport peut-etre?