Forum

Hi Rita, You might be able to do it if you turn the measure you have into a calculated column, then use SAMEPERIODLASTYEAR to show the current mont...

Hi Steve, To sort that table, you can try the SAMPLE function: SAMPLE(<n_value>, <table>, <orderBy_expression>, [<order>...

Hi, PQ will automatically detect column names from the Score After column values, using List.Distinct. You can replace this code from #"Pivoted ...

Hi Johan, Hard to imagine how your data looks like and how you get that release, whatever that release means (is it a replacement of the old data, ...

Hi Caymen, Excel is not a great text processor, detecting paragraphs or sentences might be too much for a data processor. bullet points are hard...

Hi Rachel, What expire means for you? The cell date reaches today's date, or is a few days before current date? You can play with the below c...

Hi Stephen, Macros will not work in a browser, when users are accessing that file in Excel Online. Sheet views are available to all users, so ev...

Hi David, Your answer is here: =MYUDF() =@MYUDF() Implicit intersection could occur. User Defined Functions can return ar...

Hi, You can reorganize the code: Sub SendAll() Dim Tbl as Worksheet, i as long Set Tbl=ThisWorkbook.Worksheets("Sheet1") For i= 2 to tbl.Cells...

The result of the query is editable, users can do whatever they want with the results of the query. If they want to reset, all they need to do is t...

great, thanks for feedback!

You are browsing for a FOLDER, not for a file, so you will see folders only. Once you have selected the desired folder, just press the Open button, sh...

Sorry, that merging question should be asked from the very beginning, because that changes the entire solution. It's not something you can patch on th...

Hi Stephen, Looks like a simple Pivot column operation: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Pivoted Column" = ...

Ok, so you use Get Data>From File>From Folder, the folder browser dialog is displayed. Have you tried to select a folder from that dialog and cl...