Forum Discussion
concatinated string to image url not working
- 1 year ago
Hi Anonymous ,
if its returning this:
https://openweathermap.org/img/wn/[email protected]its mean that your calculate is returning blank as result, lets breakdown this.
1- I'm supposing that you're in WeatherWrzesnia table, where you want to create a calculated column ImageUrl.
2- with this, you can create a new calculated column using this DAX:ImageUrl = "https://openweathermap.org/img/wn/" & CALCULATE( FIRSTNONBLANK(Weather[list.weather.icon], 1), FILTER( Weather, Weather[list.dt_txt] = WeatherWrzesnia[list.dt_txt] ) ) & "@2x.png"I'm not using MIN function, because calculated columns works in row context also.
let me now if this help you, try to debbug your DAX to see what the calculate returns.
Hi Anonymous ,
if its returning this:
https://openweathermap.org/img/wn/[email protected]its mean that your calculate is returning blank as result, lets breakdown this.
1- I'm supposing that you're in WeatherWrzesnia table, where you want to create a calculated column ImageUrl.
2- with this, you can create a new calculated column using this DAX:
ImageUrl =
"https://openweathermap.org/img/wn/" &
CALCULATE(
FIRSTNONBLANK(Weather[list.weather.icon], 1),
FILTER(
Weather,
Weather[list.dt_txt] = WeatherWrzesnia[list.dt_txt]
)
) &
"@2x.png"
I'm not using MIN function, because calculated columns works in row context also.
let me now if this help you, try to debbug your DAX to see what the calculate returns.
- Anonymous1 year agoNot applicable
Works, thank u