Forum Discussion

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago
Solved

Gauge with dynamic target

Hello community, Today I wanted to request your help to build a gauge with the following characteristics: -The target value 'MITIGOAPP v1' must be equal to the one in the current month. Example: in...
General Comment
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    here is link to pbix file, i did few things which I can explain, basically converted your "MAU" to "Month Date" for relative filtering as 1st date of the month, you can see this in power query and from there it was all easy.

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago

no, the objective value is taken from the first source of data that I showed.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

oh ok, from your data sample (1st picture) there is no data for each day of nov, 2017 but in your 2nd image, you have col K with values.

 

Anyhow, you can use lookup function to get the value from your target or if these tables are related then you can use related function.