Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
  • v-luwang-msft's avatar
    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