Forum Discussion
Helper IIINew Measures, Columns - Data sets.
Hi Lenihan
Create a master calendar table and measures.
Then as you keep adding data the master calendar table will be updated for the new dates in the data.
All the measures can then be filtered for months, quarter, year.
You can refer to lot of posts in the community for creating calendar tables.
Cheers
CheenuSing
Hi Lenihan
Is it possible for you to load the data in xlsx format and upload to One Drive / Dropbox and share the link. Also
include what kind of output are you expecting.
Cheers
CheenuSing
Helper IIII wish I could provide the data, as I know that would be much easier, but the data is corporate confidential.
I think though I know what I'm supposed to do with respect to this question. Correct me if I go astray:
I originally assumed that I had to keep adding new tables of monthly data, and then create new measures for each month of data added. I'm a little further in my book I'm reading now, and if I understand, I should be just merging the new data. As long as I'm adding a column called reporting month, I'll be able to differentiate the old data and the new data. The measures will be valid for ALL the data there, even the new data added. Is that right then?
Hi Lenihan
Create a master calendar table and measures.
Then as you keep adding data the master calendar table will be updated for the new dates in the data.
All the measures can then be filtered for months, quarter, year.
You can refer to lot of posts in the community for creating calendar tables.
Cheers
CheenuSing
- Lenihan
I'm having much more luck now with the master calendar table - thanks!