Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

concatinated string to image url not working

I'm fetching data from openweathermap api. Then I'm trying to create image url string to fetch image: ``` ImageUrl = "https://openweathermap.org/img/wn/" & CALCULATE(     FIRSTNONBLANK(Weather[li...
  • Bibiano_Geraldo's avatar
    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.