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!

v-sdhruv's avatar
v-sdhruv
Community Support
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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi

 

that worked - thank you so much for your help