Forum Discussion
Monthly Average from Daily Date Values
Hi figo12
If I understand you should be able to consolidate all your sheets into one dataset, which will then mean that you now have got one Date field in your data, in which you can then map to your Date Table.
In order to consolidate all the sheets, you would do this in the query editor, and possibly either use the Folder Source, or use the Append function to put them into one dataset?
Hi GilbertQ yes sorry I already have that, what I am looking is just a measure that will accomplish my goal, I already have a date value related to all tables, and created a month id for each date, there must be a way to achieve this on a measure.
It is the same data sheet, single excel file, it is just like 20 pages on same excel file.
Hi figo12
If that is the case you can then simply use the measure I provided earlier?
And then on your Axis put in your Month and on the Values put in the Calculated Measure. That will then give you the average for each month.
Thanks GilbertQ that would work fine, but what I am trying to implement is the KPI Gauge chart (sorry for been such a difficult case).