Forum Discussion
Solved
Create relationship between measures and column from another table
Hi folks, I ran into a problem when trying to display icons for weather forecast in my PBI dashboard. To give you a bit more detail - I need to show icons for current week (which is selected in the ...
Hi DJOXXXA
You can create another Measure for previous week, year icon using same logic as you did to return the description or use something like below.
PrevIcon = VAR _prev = { [PrevDesc] } RETURN CALCULATE( SELECTEDVALUE( icons[Icon] ), ALL( icons ), TREATAS( _prev, icons[Desc] ) )This measure will use the result of your current measures and find the corresponding icons, like below.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi DJOXXXA
You can create another Measure for previous week, year icon using same logic as you did to return the description or use something like below.
PrevIcon =
VAR _prev = { [PrevDesc] }
RETURN
CALCULATE(
SELECTEDVALUE( icons[Icon] ),
ALL( icons ),
TREATAS( _prev, icons[Desc] )
)This measure will use the result of your current measures and find the corresponding icons, like below.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
