Last 6 Sprints

[Suresh_M86]

I have a column called Sprint and the data is like 2022.3.1,2022.3.2,2022.4.1,2022.4.2,2022.5.1,2022.5.2,2022.6.1,2022.6.2,2022.7.1
I want to show rollback 6 sprints data in Bar chart how can I get Dax for 6 sprints (2022.4.2,2022.5.1,2022.5.2,2022.6.1,2022.6.2,2022.7.1) ?

[v-chenwuz-msft · Accepted solution]

Hi @Suresh_M86 ,

Please split them in power query editor with ". " to split them, then combine them with "/", and then convert them to date type.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Suresh_M86]

But I do not have Date field to create, still not resolved.

[tamerj1]

Hi @Suresh_M86 

please check https://youtu.be/d8Rm7dwM6gc