Display Month Range

Follow

Master Yoda

January 20, 2020 18:10

I would like to display on my pivot the date range a task was worked on.

I do have a timestamp in my cube but the format is 1/1/2020 10:11:00.

I want to display January - March in a column which is month range a task was worked on .

Can you help me with this ? 

0

• 

  Nathan Giusti January 31, 2020 16:05

  In your cube you'll have to create a new column for Month category and tag the data there appropriately. 

   

  So your custom column would be something like

   

  CASE WHEN GETMONTH(date) BETWEEN 1 and 3 then "Jan to Mar"

  WHEN GETMONTH(date) BETWEEN 4-6 then "Apr to Jun"

  etc

  0

  Comment actions Permalink

Please sign in to leave a comment.