Need to show current sprint and previous sprint

[Anonymous]

I am learning Power BI, I have a requirement, need to show current sprint and previous sprint details using slicer. I created the slicer, how to get the previous sprint and current sprint data. I have sprint completion date, sprint start date and sprint end date column. 

[amitchandak]

@Anonymous , You can create a table with Sprint, Sprint start, and end date. You can have rank on the start date

Sprint Rank = rankx(Sprint, [Sprint Start Date],,asc, dense)

Then you can use that for measure like

This Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Sprint),Period[Sprint Rank]=max(Sprint[Sprint Rank])))
Last Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Sprint),Period[Sprint Rank]=max(Sprint[Sprint Rank])-1))

Join with your table on sprint or sprint start date

same as custom time intelligence

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s