So I'm building a dashboard that has three dataflow/sets and each datasets has a corresponding dates: SLT Date,CaseDate and DateCreated. What I want to achieve is create a single monthly date so that I can put it in a table and put each different KPIs for each dataset.
Basically one unified date for each KPI metrics on my multiple date. Is it possible if so how?
Additionally is there a formula to create a moving 6 months median?