Forum Discussion
DebbieE
Community Champion
Community ChampionKPIs using None Standard date Periods
say you have the following KPI based on a Monthly report Indicator: Fact Target Goal: Last Month fact Trend Axis Date (Month from the data hierarchy) But I also have reports based on Tim...
DebbieECommunity Champion
Community ChampionIm wondering if I can create a date table with the Min date from Dim date where Rolling 12 month flag is 1 and the end date is Max Date where Rolling 12 Months flag is 1?
Im not sure how to go about it though, or how that will help me with the KPI at the moment
Also If I create a date table will that remove all the date hierarchies from my dates in DimDate? I dont want that to happen
kentyler
Solution Sage
Solution SageA date table is usually recommended for all power bi projects. It would replace, rather than removing your current date hierarchies. There are a lot of issues. Would you like to do a screen share and talk through them. Send me a convenient time and date in an email ([email protected]) and i'll send you a meeting invitation.