Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Creating a percentage complete based on dates

Hi  I wonder if anyone can provide me with some help. I have a check that is completed once a quarter and the results of that check(completed via a form) are sent into PBI so we can show who has co...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Anonymous ,

    Thank you for sharing the file and explaining in detail. Although I couldnt find completion Date in ShopList Table.
    You can try this measure in your file :

    Quarterly Completion % =
VAR TotalShops = CALCULATE(DISTINCTCOUNT('Shop List'[Shop Name]), ALL('Shop List'))
VAR CompletedShops = 
    CALCULATE(
        DISTINCTCOUNT('Shop List'[Shop Name]),
        FILTER(
            'Shop List',
            'Shop List'[Date Completed] >= MIN('Date Table'[Date]) &&
            'Shop List'[Date Completed] <= MAX('Date Table'[Date])
        )
    )
RETURN
DIVIDE(CompletedShops, TotalShops, 0)

    Let me know if it works for you.
    Thank You!

danextian's avatar
danextian
Super User
1 year ago

Hi Anonymous 

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind (for example for row1, what are your expected values and why?). You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.