Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a month field and year field but data is like FY-15, FY-16 and no date field . Is it possible to create a calendar with those fields and finally is it possible to calculate YTD's , MTD's and prior year calculations from the calendar created.
Thank you,
AJ
Hi Aj
Attached is a master calendar created out of FY-15,FY-14 fiscal year field
You will not be able to get MTD Sales as you do not have in your fact Table month. However you can have YTD and PriorYTD
Yes you can but you will not be able to calculate MTD measure. You will only have the YTD and Prior YTD measure.
The Field value FY-15 contains only year information and no month
Thanks for the replay Ziad. Could you please help me to create the calendar. Thanks in advance.
-AJ
Hi Aj
Attached is a master calendar created out of FY-15,FY-14 fiscal year field
You will not be able to get MTD Sales as you do not have in your fact Table month. However you can have YTD and PriorYTD
This is a discussion, I didn't know anything about calendars,
And only through the video i got it ..
Good Luck
-Angel