Forum

tan yan
@caroltxy
Eminent Member
Joined: Apr 18, 2020
Topics: 5 / Replies: 12
Reply
RE: is there a way to auto display "grant total" at the bottom of last row in power query, before transform into excel

apologize for being new here and not really catch on how to turn on "totals" in excel tables..Does it mean auto sum function in excel..wonder if you c...

5 years ago
Forum
Reply
RE: 6.11 Concatenating "00:" to values in gap column returns nulls

Hi, dont mind if i wish to clarify my concern below about section 6:11 Try ...Otherwise vs If then else could anyone tell me the differen...

5 years ago
Forum
Reply
RE: How to tidy up my combined files in Power Query with repeated rows

super fantastic! i manage to work out by my own by opening the new workbook & new query, by referring to your applied steps in power query 🙂 ...

5 years ago
Forum
Reply
RE: How to tidy up my combined files in Power Query with repeated rows

sorry Mynda...don't mind if you could work out 1 sample over here... i tried to transpose first 4 rows GSTIN", "legal name", "from" and "to" i...

5 years ago
Forum
Reply
5 years ago
Forum
Reply
RE: Can I perform SUMIFS in Power Query without a lot of fuss?

Yes, you are right. lot of identical rows appeared after testing...not sure if any other better option is available here instead? anyway, thanks f...

5 years ago
Forum
Topic
Forum
Replies: 1
Views: 52
Reply
RE: Handling multiple worksheets and assigning dates

oh yes, you are right. Mynda! thanks for remind me 🙂

5 years ago
Forum
Reply
RE: Handling multiple worksheets and assigning dates

sorry...another query relate to 3.02 practice. since all data were consolidated in the new worksheet of same workbook (i called it as "consol...

5 years ago
Forum
Reply
RE: Can PowerQuery combine all PDF copies and transform into single excel spreadsheet?

thanks alo Catalin Bombea said Hi, Power BI desktop has an option to import data from PDF files. Use the From Folder option, and make sure you ha...

5 years ago
Forum
Reply
RE: Connection to SQL Developer

thanks...your info. help me alot! i will send this link for my IT Team to study and work out for me 🙂

5 years ago
Forum
Page 1 / 2