Forum Discussion
Dynamically Incrementing Month Index
- KevinColes5 years ago
Helper III
Hi Caiyun,
I'm unable to provide data as it is sensitive and it is a very large pbix file.
What I'm wanting should be generic enough. I need to know the current column count of each column where a specific measure (in this case revenue) is greater than 0.So given someone selects 12 months on the slicer, but revenue is 0 until month 9, that should be a count of 1 month, then month 10 would be a count of 2 months, and so on. My date table has an index column but I need to know a simple count of months with Revenue in the current column. I've shown this below. I will probably need to accomodate a $0 month in between as well but for now this is about a new Project Manager who would have no Revenue until Month 9 so I need to calculate his DSO based on an averaging of the Revenue he does have, hence the need for the month count.
Thanks,- Ashish_Mathur5 years ago
Super User
Hi,
I am interested in helping. Can you share a small anonymised PBI file and show the expected result there.
- KevinColes5 years ago
Helper III
Hi Ashish,
Sorry for the delayed repsonse. I will try to put together something in a separate file to simulate this and upload it.
Thanks!