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:
