michaelg25

Discussions

Group By Issue
I need assistance with identifying transactions that net out to zero in a large dataset. Each row in the dataset represents a unique transaction with its own ID. Objective: Identify pairs of transactions that meet the following conditions: Same client ID Same transaction type ID Same transaction date The sum of their…
Formula to calculate date of Monday of previous week
Hello! I have a card that is filtered to the previous week. In the title of the card, or in a summary number within the card, I'm trying to show the start date of the data. Something like: "Card Title | Week of 9/9/2024" And the date portion of that title would be automated. Every week when the card details change, that…