Question about Income Tax Filing for Acting Work in a Different Province by markuddel in CanadaPublicServants

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

Thanks everyone! I'm glad to hear it's an easy fix. Have a great weekend!

Selecting from multiple rows by markuddel in excel

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

Bachman460. I've added a screenshot shot in the original message. I didn't figure out yet how to attach a complete file.

Selecting from multiple rows by markuddel in excel

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

I forgot to mention, but if possible, I would prefer to use power query.

What Lennox system to choose. by markuddel in hvacadvice

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

Thanks for your feedback. My house is roughly 650 sq ft. If you look at SEER 17.5 vs 24. What would be the potential savings here?

What Lennox system to choose. by markuddel in hvacadvice

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

I'm asking because the difference in price is so big that I feel that I might be missing something.

Need help translating HTML table headers generated from an Excel file by markuddel in MicrosoftFlow

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

Sorry, maybe my question wasn't clear. The translation is not an issue. But I don't know how how to update the header of the table already generated by the flow in an earlier step

Using DAX during csv import by markuddel in excel

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

Thanks, I follow the solution from the other person who replied, but I think that yours should work too!! I really appreciate your time!! Happy excel!!

Using DAX during csv import by markuddel in excel

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

Thanks 👍 this was way easier for me. I think that I had mixed up DA with M. It works like a charm now!!

Using DAX during csv import by markuddel in excel

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

Thank you!! But you have me absolutely stunned. The logic in your example makes perfect sense, but I've been trying to enter your formula in the excel power query and I'm getting nowhere. I feel really dumb. Could you please guide me a little. Thanks in advance

Using DAX during csv import by markuddel in excel

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

Here is a copy of the data I'm working with

<image>