Creating a DAX sprint column for Kanban Metrics (MS Power BI)


I am trying to create a DAX column within the table above that gives me rolling 3-week sprints for work items that were closed within a certain date period. These are some of the following date periods:

  • 2/10/20 – 3/01/20
  • 3/2/20 – 3/22/20
  • 3/23/20 – 4/12/20
  • 4/13/20 – 5/3/20
  • …etc

With the fields available in my screenshot, how can I make a DAX column for this? Thank you.

Go to Source
Author: ookafor