Forum Discussion
KPIs using None Standard date Periods
Im 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
A 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.
I already have a date table dim date which is my date table and I dont want to replace it with another one just for this issue.
Thank you so much. Ill see if I can get some time tomorrow. That would be great
Just let me know. I'm on PST and I'm available after 8:00 am
thanks for the offer.
Im going to have to rethink this, with it being a customer report I cant really show it so I would have to set up another test report which may take a while.
I genuinely think the answer is that the KPI must include something from a date hierarchy so if you dont use standard date periods you cant base a KPI on it. which is a real shame
You could include another calendar table, linked to the data you want to draw the KPI from. That would allow you another date hierarchy
How though
How could I create another date table using the flags in Dim date I have already set up?
date flag
01/01/2010 1
02/01/2010 1
03/01/2010 1
04/01/2010 1
Take date Between Min date and Maz date Where flag = 1