Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

custom column from counting the rows after filtering a table for a date 6 months ago

Hi Community,   I need some help with creating a custom column in power query of dataflow.   I am trying to find the number of providers churned in a particular account within a period of six mon...
dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

I read your description and found that the content of my first response was not problematic. The only point of confusion is:

The boundaries between 'before and after' and 'between and' are different. Are you sure you want to calculate the value excluding these two days?

 

Best Regards

Janey Guo