NOTE: Changes in Workout Frequency
|
|
12
|
860
|
June 14, 2023
|
New book: The Definitive Guide to Power Query (M)
|
|
10
|
727
|
April 8, 2024
|
Power Query Workout 09 - Extract Part Number
|
|
16
|
1233
|
June 28, 2023
|
Power Query Workout 10 - Eliminate Returns
|
|
18
|
1770
|
June 8, 2023
|
Data Visualization Workout 012 - Scatter chart - Quadrant highlighting
|
|
43
|
2938
|
September 17, 2023
|
Data Visualization Workout 009 - KPIs & Targets
|
|
38
|
3928
|
March 31, 2024
|
Power Query Workout 13 - Find Correct Department
|
|
12
|
941
|
June 27, 2023
|
Data Visualization Workout 013 - Grouping: Top / bottom & others
|
|
37
|
3174
|
March 12, 2024
|
Data Visualization Workout 011 - Cost Analysis - Scenario comparision
|
|
22
|
2957
|
April 29, 2024
|
Power Query Workout 12 - Supplier Invoices
|
|
11
|
1273
|
June 19, 2023
|
Power Query Workout 11 - Define Segments
|
|
15
|
972
|
June 12, 2023
|
Data Visualization Workout 010 - Cost Analysis - Small Multiples
|
|
21
|
2444
|
August 14, 2023
|
Power BI Desktop July 2023 Released
|
|
13
|
1862
|
July 17, 2023
|
Excel Workout 17 - If Function!
|
|
14
|
1264
|
February 17, 2024
|
Deneb Workout 10 - Line Chart with Hover Highlight
|
|
19
|
1606
|
August 26, 2023
|
Excel Workout 21 - Index Function!
|
|
11
|
1072
|
July 15, 2023
|
On duplicate rows of first column move data in other columns leaving only unique values in first column
|
|
22
|
943
|
August 1, 2023
|
Cannot Reply to Some Topics - Yet Again!
|
|
21
|
1094
|
November 22, 2023
|
Excel Workout 24 - Filter, Unique & Xlookup Functions (Recipe Cost Calculator)!
|
|
16
|
1407
|
August 6, 2023
|
Regex workout not getting 50 xp still not working (june 13) (updated on June 27)
|
|
19
|
766
|
July 14, 2023
|
DAX Workout 020 - Dynamic Titles and Subtitles
|
|
15
|
1281
|
May 30, 2023
|
Pivot Table in Excel to PowerBI
|
|
10
|
743
|
November 29, 2023
|
Excel BI Power Query Challenge Workout 077
|
|
30
|
1472
|
April 24, 2024
|
RegEx Workout 003 - Tokenization
|
|
13
|
592
|
June 8, 2023
|
DAX Workout #24 - Highlighted Value in a Line Chart
|
|
10
|
1996
|
March 27, 2024
|
RegEx Workout 002 - Character classes and alternatives
|
|
12
|
594
|
June 8, 2023
|
Visual like teams calendar in Power BI
|
|
9
|
448
|
February 6, 2024
|
Excel Workout 23 - INDEX Function (CEV EuroVolley Challenge)!
|
|
20
|
1374
|
August 6, 2023
|
Count of employees with several conditions
|
|
12
|
682
|
July 17, 2023
|
Excel BI Challenge Workout 197
|
|
38
|
809
|
April 24, 2024
|
Excel Workout 22 - IFERROR & VLOOKUP Functions!
|
|
14
|
1064
|
January 16, 2024
|
DAX for month-to-month changes at row level
|
|
11
|
649
|
July 4, 2023
|
Issue with Measure in Decomposition chart
|
|
11
|
614
|
October 10, 2023
|
Custome col in Power Query
|
|
20
|
857
|
June 1, 2023
|
Excel BI Power Query Challenge Workout 076
|
|
17
|
814
|
May 30, 2023
|
Excel BI Challenge Workout 200
|
|
25
|
746
|
April 24, 2024
|
KPI Card with Actual to Prior Year Bar & Variance
|
|
9
|
1007
|
November 16, 2023
|
Change data type gives error
|
|
10
|
634
|
June 12, 2023
|
Reply: Split a single row into multiple rows based on multiple colums
|
|
10
|
521
|
September 12, 2023
|
Excel BI Challenge Workout 198
|
|
28
|
720
|
May 25, 2023
|
Help customize Deneb heatmap
|
|
16
|
740
|
October 19, 2023
|
Excel BI Challenge Workout 201
|
|
20
|
647
|
April 24, 2024
|
Excel BI Challenge Workout 199
|
|
21
|
822
|
April 24, 2024
|
Excel Workout 26 - Histogram Chart!
|
|
11
|
989
|
August 26, 2023
|
RegEx Workout 005 - Word identification
|
|
9
|
619
|
June 18, 2023
|
Adding Rows to get a Total
|
|
21
|
543
|
January 8, 2024
|
Grouping "Other" In Bar Chart Using Ranking
|
|
15
|
586
|
November 24, 2023
|
Excel BI Power Query Challenge Workout 075
|
|
19
|
654
|
April 24, 2024
|
Measure columns one sum multiple columns
|
|
10
|
627
|
April 19, 2024
|
[Deneb Question] How to create rectangle borders on specific values?
|
|
10
|
745
|
August 31, 2023
|