Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data Mapping

I have two tables in Analysis services. one is date table which has (Date, Month, Year, Year of Month) 01/01/2013 1 2013 20131 01/02/2013  1 2013 20131 01/03/2013 1 2013 20132 unil 2020 Dec and S...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, Amit. I was looking for mapping between two tables.

I have created a static table in the Database and pulled to analysis services, and then trying to calculate the YTD ship dates based on Year, Month selection from Date table. However, the cumulative or YTD is not working on Shipdays table for shipdays.

I have a table (ship days) like below

Year of Month(int), ShipDays(Int)

201801,20

201802,21

until

202012,20

 

I am not sure what went wrong in this scenario? what is the best approach to join these two tables in calculating the ship days

 

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

You might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.