Track Number of Days Item Spends in a Stage

[SJCee]

We are using a Sharepoint list to track individual items, each item sits within one of three stages. Each item can move forward a stage as well as backwards.

Is it possible in Power BI to have a counter that will track the number of days and item spent in each stage? 

Thanks,

Sam

[some_bih]

Hi @SJCee to calculate difference in days DAX  function which could be used is DATEDIFF, see example https://learn.microsoft.com/en-us/dax/datediff-function-dax hope this help