Forum Discussion
Monthly Average from Daily Date Values
Hi figo12,
The COUNTROWS just counts the number of rows.
So if you wanted to get the Average per month, you would either need to have a date table and create a relationship from your data's Date to the Date table.
Or to use the built in time intelligence and use the Month.
This will allow it to show the average per month.
Hi GilbertQ I already have the date value on date table (01/01/2017) related to the Sales Table Date, thing is I have like 20 data sheets that I would need to create a new month column and relate it to the primary date table, I believed there was an easier method in order to accomplish the goal. But thanks for your sugggestion anyway.
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.