Download the latest Visual Studio Community Edition (about 4gb). Then start a new Project “Console VB.NET” and use the following…
Qlik Sense SetAnalysis and Power BI Dax Comparisson
For my new job I have to move my skills from qlik to microsoft power bi which – at the…
Excel macro loop by sheet
Collect data from multiple excel tabs and put them together at a new collector sheet:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
Sub WorksheetLoop() Dim WS_Count As Integer Dim I As Integer ' Set WS_Count equal to the number of worksheets in the active ' workbook. WS_Count = ActiveWorkbook.Worksheets.Count ' Begin the loop. For I = 1 To WS_Count ' Insert your code here. ' The following line shows how to reference a sheet within ' the loop by displaying the worksheet name in a dialog box. MA_NAME = ActiveWorkbook.Worksheets(I).Name vJanuar = ActiveWorkbook.Worksheets(I).Cells(8, 3) vFebruar = ActiveWorkbook.Worksheets(I).Cells(8, 4) vMarch = ActiveWorkbook.Worksheets(I).Cells(8, 5) vzJanuar = ActiveWorkbook.Worksheets(I).Cells(9, 3) vzFebruar = ActiveWorkbook.Worksheets(I).Cells(9, 4) vzMarch = ActiveWorkbook.Worksheets(I).Cells(9, 5) ActiveWorkbook.Worksheets(239).Cells(I, 1) = MA_NAME ActiveWorkbook.Worksheets(239).Cells(I, 3) = vJanuar ActiveWorkbook.Worksheets(239).Cells(I, 4) = vFebruar ActiveWorkbook.Worksheets(239).Cells(I, 5) = vMarch ActiveWorkbook.Worksheets(239).Cells(I, 7) = vzJanuar ActiveWorkbook.Worksheets(239).Cells(I, 8) = vzFebruar ActiveWorkbook.Worksheets(239).Cells(I, 9) = vzMarch Next I End Sub |
…
MS SQL PIVOT with text as Fieldtype
The trick is, that you cast the text/string into varchar and then you can use MAX as aggregation type to…
Power BI and MS CRM Entity Tables
Temporary Entity Tables build with DAX Query and using the CRM Tables: StringMapBase MetadataSchema.Entity…
Power BI Calender DAX
Generating a calender was a very important task within qlik sense/view – so even as the date functions within power…
T-SQL execute procedure for each row of a master table
From time to time it’s needed to loop over the rows of a master table – e.g. different companies within…
Jedox Percentage on Percentage on Percentage Split with “instant” preview
Usecase Imagine you have a customer who wants to split revenue by multiple dimensions not based upon total figures nor…
Jedox – User CRUD – Manage Dimensions within worksheet
Usecase Sometimes it´s needed that a user can add elements to a dimension without accessing the modeller – e.g. you…