Forum Discussion
Anonymous
5 years agoNot applicable
Finding Average Days Between Two Dates in Q&A Visual
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. Howev...
- 5 years ago
Hi Anonymous ,
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
v-luwang-msft
Community Support
5 years agoHi Anonymous ,
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
Anonymous
5 years agoNot applicable
The link and suggestion were what I needed. Thank you!