|
Excel BI Challenge Workout 201
|
|
20
|
603
|
April 24, 2024
|
|
Excel BI Power Query Challenge Workout 075
|
|
19
|
609
|
April 24, 2024
|
|
Excel BI Power Query Challenge Workout 077
|
|
30
|
1393
|
April 24, 2024
|
|
Display units - how to remove K
|
|
16
|
11685
|
April 23, 2024
|
|
Date slicer serving multiple purposes (current month, YTD, Rolling 12-months)
|
|
0
|
93
|
April 23, 2024
|
|
DAX Grouping Issue
|
|
6
|
465
|
April 23, 2024
|
|
Power Query and access to a folder with lots of pasword protected xlsx files
|
|
1
|
97
|
April 22, 2024
|
|
Table Transformation - Column to rows ( Split Columns & append)
|
|
5
|
166
|
April 22, 2024
|
|
How to show past four years sales by qtr using DAX
|
|
7
|
364
|
April 11, 2024
|
|
Dynamic Time Period on Visuals (Fields, Axis, and Filters)
|
|
0
|
142
|
April 19, 2024
|
|
Pipedrive CRM Integration
|
|
4
|
888
|
April 19, 2024
|
|
Measure columns one sum multiple columns
|
|
10
|
578
|
April 19, 2024
|
|
Categorise Income and expense accounts
|
|
1
|
132
|
April 19, 2024
|
|
DAX query Calculation Help
|
|
0
|
89
|
April 19, 2024
|
|
Call Centre Metrics
|
|
1
|
107
|
April 19, 2024
|
|
Annual Billing Issue/Error
|
|
5
|
133
|
April 19, 2024
|
|
Query to join sheets when the path to the file is on a network drive
|
|
7
|
287
|
April 18, 2024
|
|
How to Make DateEnd parameter equal today
|
|
5
|
174
|
April 18, 2024
|
|
Periodically aggregated rolling calculation
|
|
0
|
92
|
April 18, 2024
|
|
Challenge 19 Reporting
|
|
7
|
235
|
April 17, 2024
|
|
One Dimension, Multiple Facts -and- Multiple Interconnected Facts
|
|
32
|
9255
|
April 17, 2024
|
|
compare values from end of month M with value start of month M+1
|
|
0
|
91
|
April 16, 2024
|
|
Getting dataset for profit and loss
|
|
1
|
118
|
April 16, 2024
|
|
Previous Month calculations
|
|
7
|
467
|
April 16, 2024
|
|
Connecting to API with access token
|
|
3
|
194
|
April 15, 2024
|
|
Working with Multiple Date columns in fact table
|
|
2
|
246
|
April 14, 2024
|
|
Help with waterfall chart
|
|
6
|
378
|
April 14, 2024
|
|
RLS for 3 Tier Hierarchy -- Two Way Filtering
|
|
5
|
233
|
April 12, 2024
|
|
Deneb Example - Period Comparison
|
|
2
|
351
|
April 11, 2024
|
|
Using Variables to display Total/Sum
|
|
3
|
176
|
April 11, 2024
|