I have a number of tables which have been concatenated. I have then used the FileBaseName() function to retrieve the Excel filename and, thus, identify the month the data pertains to.
Would it be possible to organise this data into a quarter? If so, please let me know.
All the best,
If it's possible, please can provide a description of how the solution works as if I am just provided with the function, I find it difficult to understand how and why it works.
So basically 'Q' is just the text and concatenate the Quarter number. Quarter number is calculated as follows
Divide Month by 3 and then get the ceiled value for example Ceil(1/3) = Ceil(0.3333) = 1,
Ceil(4/3) = Ceil(1.3333) = 2. So show the next closest integer here.
Does it make sense?
Is it possible to take it back a stage as I am struggling.
I am trying to calculate the earliest and the latest date using the max and min function.
So the script I'm writing looks like this:
Min([MM-YYYY]) AS MinDate,
Max([MM-YYYY]) AS MaxDate
However, when I load it and go to the UI the fields are available but they do not generate any values.
Please can you help me with this?