Finding Average Days Between Two Dates in Q&A Visual

[basel777]

Hi All,

I have a Q&A visual that includes start and end dates. I would like to identify how to phrase my questions in the visual, so that I can find out how many days are between two dates. However, I'm having a hard time figuring out what phrases I should use to get this kind of result. 

I've provided an example of what my dataset looks like below:

ID	Start Date	End Date
10001	01/01/2021	07/31/2021
10002	02/01/2021	07/31/2021
10003	03/01/2021	09/30/2021
10004	07/01/2021	09/30/2021
10005	07/01/2021	12/31/2021

When I search in the visual, I have tried different iterations of "Show me the average days between Start Date and End Date" or "How many days are there on average between Start Date and End Date for each ID". My Date fields are in Date type and my ID is in whole number type. 

Any help is appreciated!

Michael

[v-luwang-msft · Accepted solution]

Hi @basel777 ,

You could click here to learn limitations of Power BI Q&A.

And if you want to show the average  form start date to end date,you could use the below dax to create a new column:

datediff = DATEDIFF('Table'[Start Date],'Table'[End Date],DAY)

Then use Q&A:

Wish it is helpful for you!

Best Regards

Lucien

[basel777]

The link and suggestion were what I needed. Thank you!