Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Assigning a Sprint column based on date field

Good Afternoon!    I am trying to assign a Sprint number to our capacity planning information within Power bi. Attached is an example of the worksheet we are pulling from and within Power BI, I wan...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi

     

    Pleasease try this code

    Sprint =
    VAR __step1 =
        FILTER (
            SUMMARIZE ( Feuil1, Feuil1[Sprint], Feuil1[Start], Feuil1[End] ),
            Feuil2[Date] >= Feuil1[Start]
                && Feuil2[Date] <= Feuil1[End]
        )
    RETURN
        MAXX ( __step1, Feuil1[Sprint] )

     

    Feuil1 is your sprint schedule

    Feuil 2 is  your capacity schedule

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you James! I am a very new user and not incredibly technical. I input what i think you were getting at and it is giving me an error. 

 

Any thoughts? Also my assumption is that i would continue to define out the sprints and their numbers before the ) Return. Is that correct? Thank you so much for your help!

 

laurilee