I need to build a spreadsheet that checks month (show values if dates are in the current month), I need to show something that looks like this:
I need the value DSO *(Which i calculate using this exspression - SUM(Customers_Aging_Exclude_Int[Customer Balance])/SUM(Monthly_Activity_DSO[Final Trx Amount]) 31 ) to show up to the side of each of those weeks above.
I want this to change according to the month.
Soโฆ next month would show Marchโฆthen Aprilโฆand so onโฆ
I have built and rebuilt the structure - but i cannot seem to get it correct. This is what i currently have:
Does anyone have a suggestion for me here?
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |