Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Using SWITCH to show previous field value

Hi,

I have this list:

Sprint 1

Sprint 2

Sprint 3

Sprint 4

Sprint 5

 

Each of the sprints has Story Points associated (Numbers)

 

For each Sprint , I need the SUM of Story Points of the PREVIOUS Sprint. (For example, for Sprint 2, I need the sum of Story Points of Sprint 1)

 

So for that, I am using SWITCH, to bring the Sprint Name and the measure of the SUM of Story Points for the PREVIOUS Sprint:

re.png

 

This is an example of the measures I have created

 

re2.png

 

Notice that in the SWITCH , I am calling the Sprint name with the measure of the previous Sprint,

 

I put the Zero just because I was testing, but, any ideas why is not working ? it is showing blank values.

 

 

Thanks in advance.

2 ACCEPTED SOLUTIONS
az38
Community Champion
Community Champion

@Anonymous 

hi. as you use a measure that enables row-context use a ALL() inside FILTER, like

SUMX(FILTER(ALL(RSRI),RSRI[Sprint Name]=....

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

az38
Community Champion
Community Champion

@Anonymous 

did you check it? I'm already not sure this works, maybe your issue is more complicated


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

5 REPLIES 5

Hi @Anonymous ,

 

if you want to learn more about this, read this blog post "Understanding Context Transition"

https://www.sqlbi.com/articles/understanding-context-transition/

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


az38
Community Champion
Community Champion

@Anonymous 

hi. as you use a measure that enables row-context use a ALL() inside FILTER, like

SUMX(FILTER(ALL(RSRI),RSRI[Sprint Name]=....

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

Thanks @az38 😎

az38
Community Champion
Community Champion

@Anonymous 

did you check it? I'm already not sure this works, maybe your issue is more complicated


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

yes, it is working with that change, thanks!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.