Hi,
I am trying to use Fiscal Calendar Data module with the Published package of my business Data. I followed the steps of the video which shows how to use Fiscal Calendar.
https://www.youtube.com/watch?time_continue=2&v=4lDrF3jx98g&feature=emb_logo (https://www.youtube.com/watch?time_continue=2&v=4lDrF3jx98g&feature=emb_logo)
To connect the Fiscal caledar to my data source, I need to add Fiscal Calendar in the date column of my source in the Lookup reference. But all i see is , everything is inactive and I cannot change anything and I dont see Lookup Reference .
Could anyone please Help me with this issue.
Unfortunately you would need to provide slightly more information.
Define "inactive".
What actual steps have you performed?
The query item in your fact table which you use to set its lookup reference to the calendar needs to be a date data type. If the fact table has such a column then it can be used. If it doesn't, you need to create a calculation which produces dates which represent the appropriate dates in the fact table.
You then set the lookup reference for each of the facts which you wish to have relative time measures.
Isn't the category of this question data modules?
Quote from: bus_pass_man on 25 Jun 2020 05:07:28 AM
Isn't the category of this question data modules?
I have moved the post to the Data Modules board... :)
MF.