Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #438: Chronological Currency Balance

braveraj
11 - Bolide
Spoiler
Date Headers Workflow.pngDate Headers Results.png
lamount
5 - Atom

Learned some new stuff with renaming headers. Good stuff. Also first time participating so if my formatting or response isn't typical, apologies.

ARussell34
8 - Asteroid

Re-ordered!

AR_438.png

 

 

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2024-08-20 060215.png
samgiroux
7 - Meteor
Spoiler
Screenshot 2024-08-19 163001.png
Qiu
21 - Polaris
21 - Polaris

@messi007 
Congratulations!

Spoiler
Challenge_438.png
gawa
16 - Nebula
16 - Nebula

Congratulation @messi007 !

 

My solution without Crosstab and Transpose. 

Iteration Macro can increase data in horizontal direction(JOIN), in the most of case in vertical direction(UNION) though.

Spoiler
Append column one by one with Dynamic Select tool with the below expression
[Name]=ToDate(DateTimeAdd([#1],[Engine.IterationNumber],"Days"))​

image.png
alexnajm
17 - Castor
17 - Castor

Done!

Spoiler
Challenge 438.png
wbasuki
7 - Meteor

My solution

Spoiler
Screenshot 2024-08-20 091720.png
the_data_guy
6 - Meteoroid

My solution!