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 December the value should be 201,515.
-The current value must be the last of a column that is in another data source.
Solved! Go to Solution.
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.
Still not very clear but i guess you are saying if nov 2017 is selected, you want to show last value from Col K from nov 2017 w hich will be 192379 as target and sum of col E will be total value will be actual, correct?
And in case dec2017, target value will be 85085 and so on...
is this correct understanding?
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.