Search results

Found a solution: Thank you so much.

Hello, I have a table like the following Using Power Query, I would like the desired output to be Any help will be greatly appreciated. thank you.

I went back to the initial idea of converting Sales & Transactions Columns into Lists. let Source = MyData, #"Grouped Rows" = Table.Group(Source, {"Product"}, { {"Sales", each List.Sum([NetValue]), type number}, {"Transactions", each...

Thank you Chihiro for your prompt response. I found a solution (a combination of my code and the solution in the thread you've suggested). let Source = MyData, #"Grouped Rows" = Table.Group(Source, {"Product"}, {{"Sales", each List.Sum([NetValue]), type number}, {"Transactions", each...

Hello, I have a data set that I grouped and now I would like to calculate the percentage that each Product makes up of the Grand Total in Sales and Transactions. My code ( shown below) is not giving me the desired output. let Source = MyData, #"Grouped Rows" = Table.Group(Source...

Thank you so much Chihiro. It works like a charm.

Hi, I am learning M Language and I really need help: I have the following 2 Power BI queries and I was wondering if it is possible to combine them into one. Query#1: let Source = myfile, #"Grouped Rows" = Table.Group(Source, {"Column1", "Column2", "Column3", "Column4"}, {{"Count",each...

Thank you so much Chihiro. It works like a charm.

Chihiro, I've extracted a sample data set and load your code to see how the DAX works. I've tried to attached a pbix file to no avail. I have couple questions: I presumed you've made a typo in the 2nd part of the IF STATMENT in the "M": you had 25 instead of 15 else...

I am new to DAX and still learning the basics. Thanks again for your help.

Chihiro, I am trying to do this in the Modelling Stage. At first I thought about creating a measure, but I think inserting a new column will make more sense in this case. if invoice is received on Dec 18, 2017. Then due date is Feb 15, 2018. Thanks for your help.

Hello, I have a table with a column named "Date Invoice Received". I would like to create a custom field "Due Date" with the the following criteria: If “Date Invoice Received” is before the 25th of the month, then Due Date = 15th of the 2nd following month, otherwise the due date is the 15th...

Awesome!! I will definitely get back in touch. Once again, thanks a lot!

Thank you so very much Kenneth Hobson!

I tested it for 10 and 15 rows and it worked; but I don't think it would work for more than 2 columns tho'.

I amended the code per your suggestion, and it seems to work: Dim txtB1 As Control 'For jrow = 1 To 2 For i = 1 To numbertxt For jrow = 1 To 2 Set txtB1 = Controls.Add("Forms.TextBox.1")...

Kenneth, I wantd to create a second UserForm. So I modified the above code to add a second column of Textboxes at Run Time. But I am still having serious problem saving the texboxes values to worksheet. I would like to have the results saved in sheet1.[A:B]. Could you please help again? Here...

:):):) I spent hours trying to figure out what I was doing wrong. Thank you Kenneth Hobson. I truly appreciate it.

Hi I have a userform where all the Labels and TextBoxes are created at Run Time. I got pretty much everything set up correctly except for the most important part: Transferring textboxes data from Userform to the worksheet. For some reasons, the code for the CommandButton1 keeps giving me an...

I made a typo in previous message. In step 2, please read: 2. for each month displayed in X1:AI1, get a monthly average of the weekly count obtained in step 1, for each Location ID- that's what's in Table V1:AI13

Hui. I am truly sorry for not providing an explanation. What I need is to get a monthly average of a weekly count of entries for each Location. Here are the steps I've followed to achieve that: get a weekly count of entries by Location ID- that's what I have in range A2:O126. Column P is just...

Hello, I've been reading on Excel VBA Loops & Arrays (Passing Arrays to procedures......) and spent quite some time working on the attached file. I finally got it working fine; but I believe the result needs some expert's touch. :) I was wondering if , using Arrays or Dictionaries or...

SirJB7, We just wanted to avoid code execution when clicking Cancel. Regards.

Hi, SirJB7 Sorry, I was out for couple of days; I didn't get to tweak your code yet. is it something you could do, please ? Regards.

Thank you SirJB7.