Auto update sprint data in power BI ADO Data set

[Sathish_1994]

Hi Team,

 I need to automate the sprint update in my card visual, based on this condition ( Current sprint - 1, Prior sprint), Kindly help me with what Dax should I use for the automation, currently am changing manually in my local desktop and publishing.

[Anonymous]

Hi @Sathish_1994 

I have some questions to ask you .

1.  Is the Sprint column a known column, or do we need to create a column ?

2. Why the day in Sprint column is 22 for each row ? Can you explain the computational logic ?

3. What are your criteria for judging A or B ?

4. If the two values in the card visuals need to be created by us, then they are all reflected in the form of text, right ?

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sathish_1994]

Kindly help this 

[amitchandak]

@Sathish_1994 , how is your data, is there a sortable column go know that like sprint no

Max sprint = maxx(allselected(Table), Table[Sprint])

last Sprint = Max sprint = maxx(allselected(Table), Table[Sprint]) -1

or

last Sprint = Max sprint = maxx(filter( allselected(Table) , Table[Sprint] < [Max sprint] ) , Table[Sprint])

[Sathish_1994]

I have tried the DAX that you have mentioned but the month field is text, it will not convert number error showing, I have a sprint start date, end date, and the sprint column, now we want a DAX function that changes  automatically the sprint name for card visual  ( Current sprint -1)( prior Sprint)