Forum Discussion
custom column from counting the rows after filtering a table for a date 6 months ago
This is is not getting the expected output. In the file, we have one ID for 1042-1034 and it should give 4 in the next cell as 4 providers have churned in Account_1 within last six months of the churn date for this provider.
This formula is giving me somehow multiple IDs with varied numbers across cells. Please check the screenshot of the output once and desired output.
Community SupportHi, Anonymous
No obvious logic can be seen from your two screenshots and I am confused by your description. Can you provide sample data with correct data structure? So we can help you soon.
Best Regards
Janey Guo
I am sorry that I have not been able to explain the logic clearly. Let me explain it again. Please find the logic PDF here.
Hope, this is helpful for you to understand the logic. Lemme know if I can explain any part further.
Please find the sample data here. The data has been shared via google drive links. Lemme know if you have any difficulty accessing the logic PDF or the sample data.
Thank you.
- v-janeyg-msft
Hi, Anonymous
I'm sorry. I tried hard to understand your logic. It’s really hard to understand by comparing your description and data screenshots. My colleague is just as confused as I am, so it is difficult to help you further. Can you tell me the difference between the result of my first reply and the result you want? Can you show the image(You can directly enter the correct column for reference) of the result you want in pq without just say one or two?
Best Regards
Janey Guo
Okay v-janeyg-msft no problem. I will try again to explain the logic with some screenshots of expected outcomes at each step. Please check this once. Let me know if any step you are finding confusing or difficult to understand.
Thanks and Regards
Sabyasachi