Last seen: Jul 3, 2025
Hi Tyler, Try adding a Week of Year column, each day in a specific week will have the same week number. You can also choose the first day of the we...
Hi Luciana, Don't use DAX that much for myself, did not met this problem before. Will look into that to see if I can come up with a more efficient...
As you can see, the line I sent has this: Link:=msoFalse You can change it to true if you want to keep the link to original object. At the beginnin...
Why do you want to split data? It's best to keep it together, there are many reasons why splitting is a bad idea. You can easily add a pivot table ...
Hi, Dim is used for declaring the object name and type, "Set" is to assign a value to it. Set is used for objects only, not for all variables, f...
A desperate solution might be as well to install Open Office, create your form then save as xlsm and use in in Excel for Mac. Open Office works in Mac...
Serge KIEFFER said my XLS version is ver16.16.17 Unfortunately, can't help you on Mac issues. I can see that Version 16.16.17 (Build 19120800) ha...
Hi Serge, What version of excel are you using? The latest version is... NOT XLS, xls is associated to excel 2003. I do have the latest office ve...
Hi Luciana, If you use variables, is it faster? RunBal3:=Var Acct=MAX(Main[Stmt Acct #]) Var Indx=MAX(Main[Index]) Return CALCULATE ( SUM(Ma...
How slow? 1 minute, 1 hour?
Hi Luciana, When you add the index column in the Main query, make sure that the table is sorted properly by Posted Date and that detail column befo...
There is always an alternative, you can build your own logic and steps. Considering the first 2 column of the sample data you provided, you can use...
Hi John, I think it's better to create another manual log table with those additional columns and the record ID to match with the original data rec...
Hi Luciana, Add ALL(Main[Depositor/Payee]) to CALCULATE context, or use the following simplified measure: RunBal3:=IF ( COUNTROWS(Main)>0...
Hi Junko, The chart might not be refreshing for some reason, add this code above Sleep(1000) line: DoEvents ActiveSheet.ChartObjects("Chart 2")....