Reply
Occasional Visitor
Posts: 1
Registered: ‎12-06-2018

Add in information about grouping to Date DIM table

[ Edited ]

Hi everyone,

 

Apologies if this is a simple fix. I would like to apply information about what "sprint" the dates are to my DIM table (a column that just has the sprint each date is in).

 

My date DIM table has the following information:

 

Date_DIm.PNG

 

And my date Sprint info table has the following information about dates:

sprint details.PNG

 

I tried doing a lookup on the start date, but realized that won't work for the last day of the sprint. 

 

I would ideally like the Date Table to have the following columns

 

Date | Sprint | Year | ....

 

Any help would be greatly appreciated.

Super User
Posts: 3,755
Registered: ‎01-14-2017

Re: Add in information about grouping to Date DIM table

Hi,

 

Your question is not clear.  Share the link from where i can download yoru PBI file and show the expected result.