topic Re: Last 6 Sprints in DAX Commands and Tips

Last 6 Sprints

Suresh_M86 — Tue, 27 Sep 2022 13:37:17 GMT

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) ?

Re: Last 6 Sprints

tamerj1 — Tue, 27 Sep 2022 14:06:58 GMT

Hi Suresh_M86

please check https://youtu.be/d8Rm7dwM6gc

Re: Last 6 Sprints

Suresh_M86 — Tue, 27 Sep 2022 17:20:12 GMT

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

Re: Last 6 Sprints

v-chenwuz-msft — Wed, 28 Sep 2022 10:02:23 GMT

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.