Forum Discussion
Distinct Count by Year
Greg_Deckler Ok so I found out the issue. There are 18 distinct months becuase there are 2 different plan years and they overlap by 6 months. So I also need to filter not only by plan year but also by the account. I'm still working on figuring out how to do so, but that is the last part here. Thanks!
I'm just pure guessing on this stuff Anonymous because no sample data and expected output to go off of. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I could make a suggestion with the formula because it only referenced one table but I have no clue where your account column is coming from or how it is related or what columns are in the visual, etc.