Facilities not covered for a period of more than 7 days

[MuthalibAbdul]

I am looking to get a the list of "Location" that were not covered or not visited consecutively for over 7 days

Summary: Coverage Sheet that has the name of the facility and their locations (GIS Data)

Merged: final table that has data from all physicians, the locations that they visited and when did they visit

I was asked to present the list of facilities that were not visited within 7 days of been visited. 

[v-hashadapu]

Hi @MuthalibAbdul , Hi, it's been a while since we last heard from you. We are ready to assist you with resolving the issue, but we need the necessary details from you. Kindly share the information required so we can better understand and address your issue.

[v-hashadapu]

Hi @MuthalibAbdul , Please share your sample data along with the steps you took till now along with any other relevant details that will help us solve the issue. We are always ready to help.

THank you.

[v-hashadapu]

Hi @MuthalibAbdul , Thank you for reaching out to the Microsoft Community Forum.

As already mentioned by @Greg_Deckler and @FBergamaschi ,please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[FBergamaschi]

Hi @MuthalibAbdul ,

as @Greg_Deckler wrote, we need more info, explanations, sample of data, expected output with an example

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[MuthalibAbdul]

not able to upload file. 

[v-hashadapu]

Hi @MuthalibAbdul , good morning. 

Can you please specify how you tried to upload the file and what the error was? Also, can you please confirm if you tried the methods i suggested in my earlier reply.
Thanks. 

[Greg_Deckler · Accepted solution]

@MuthalibAbdul Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.