Update: I was able to get exactly the count i need month over month using this: =CALCULATE( COUNTROWS(fact_orders), FILTER( fact_orders...
Riny, thanks so much. i think that gives me a good starting point to work towards solving my problem short term. i'm thinking long term this would...
Thanks for replying Riny. Let me see about scrubbing my data, as it does have some sensitive company info, but maybe this will give some context if ...
I'm hoping this might add some clarity to my questions. This is a sample of some orders. I'm trying to count orders in an "Ordered" PO status mo...
For additional context of the Month-Over-Month Logic: January: 250 active orders (200 carried over from previous periods + 50 new Jan POs). Februa...
Life saver! Thanks so much. I can't believe I wasn't able to figure that out.
Thanks, Mynda. Helpful as always.
Fairly certain i resolved my issue with this formula. Countrow of the table and then filter based on status and a > than date. ...
I can't believe these problem is stumping me so much. Below are the two options I have tried to 1) count rows based on a status that also contains a ...
Hi Mynda, I have not, but I will. I did try this measure, and it appears it works, but I'm not 100%. =CALCULATE(COUNTROWS(Opportunitie...