Forum Discussion

rachoksh's avatar
rachoksh
Regular Visitor
9 years ago

Sharepoint usage

How can I find unused SharePoint online site collections that have been abandoned for more than 6 months?   Can O365 Content pack for Power BI help me with this?   Thanks  
Anonymous's avatar
Anonymous
Not applicable
9 years ago

rachoksh,

Create a measure using the DAX below to check the minimum date in your table, maybe the minimum date is within 7/180 days.

MinDate = MIN('TenantSharePoint-Usage'[ContentDate])

Regards,
Lydia

rachoksh's avatar
rachoksh
Regular Visitor
9 years ago

Still the same output - :smileysad:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    rachoksh,

    What is the result does the measure return?

    Regards,
    Lydia

  • rachoksh's avatar
    rachoksh
    Regular Visitor
    9 years ago

    How do I get result for just his measure? Sorry for the delay.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    rachoksh,

    Drag the measure to a Card visual.

    Regards,