|
Creating a custom function to extract data from folder based on extension
|
|
2
|
199
|
April 24, 2024
|
|
Excel BI Challenge Workout 196
|
|
33
|
803
|
April 24, 2024
|
|
Excel BI Challenge Workout 197
|
|
38
|
813
|
April 24, 2024
|
|
Excel BI Challenge Workout 199
|
|
21
|
827
|
April 24, 2024
|
|
Excel BI Challenge Workout 200
|
|
25
|
747
|
April 24, 2024
|
|
Deneb Examples - Enhanced Gantt Chart
|
|
3
|
1043
|
April 24, 2024
|
|
Excel BI Challenge Workout 201
|
|
20
|
651
|
April 24, 2024
|
|
Excel BI Power Query Challenge Workout 075
|
|
19
|
656
|
April 24, 2024
|
|
Excel BI Power Query Challenge Workout 077
|
|
30
|
1475
|
April 24, 2024
|
|
Display units - how to remove K
|
|
16
|
11875
|
April 23, 2024
|
|
Date slicer serving multiple purposes (current month, YTD, Rolling 12-months)
|
|
0
|
138
|
April 23, 2024
|
|
DAX Grouping Issue
|
|
6
|
508
|
April 23, 2024
|
|
Power Query and access to a folder with lots of pasword protected xlsx files
|
|
1
|
129
|
April 22, 2024
|
|
Table Transformation - Column to rows ( Split Columns & append)
|
|
5
|
212
|
April 22, 2024
|
|
How to show past four years sales by qtr using DAX
|
|
7
|
426
|
April 11, 2024
|
|
Dynamic Time Period on Visuals (Fields, Axis, and Filters)
|
|
0
|
189
|
April 19, 2024
|
|
Pipedrive CRM Integration
|
|
4
|
910
|
April 19, 2024
|
|
Measure columns one sum multiple columns
|
|
10
|
628
|
April 19, 2024
|
|
Categorise Income and expense accounts
|
|
1
|
158
|
April 19, 2024
|
|
DAX query Calculation Help
|
|
0
|
113
|
April 19, 2024
|
|
Call Centre Metrics
|
|
1
|
141
|
April 19, 2024
|
|
Annual Billing Issue/Error
|
|
5
|
171
|
April 19, 2024
|
|
Query to join sheets when the path to the file is on a network drive
|
|
7
|
321
|
April 18, 2024
|
|
How to Make DateEnd parameter equal today
|
|
5
|
218
|
April 18, 2024
|
|
Periodically aggregated rolling calculation
|
|
0
|
125
|
April 18, 2024
|
|
Challenge 19 Reporting
|
|
7
|
303
|
April 17, 2024
|
|
One Dimension, Multiple Facts -and- Multiple Interconnected Facts
|
|
32
|
9359
|
April 17, 2024
|
|
compare values from end of month M with value start of month M+1
|
|
0
|
131
|
April 16, 2024
|
|
Getting dataset for profit and loss
|
|
1
|
147
|
April 16, 2024
|
|
Previous Month calculations
|
|
7
|
498
|
April 16, 2024
|