Forum Discussion

msommerf's avatar
msommerf
Icon for Helper III rankHelper III
6 years ago
Solved

Date Slicer - Custom Phases

Hi, I have a date table which defines the phases of a project every year as follows:   Phase 1 = 1st January - 31st July Phase 2 = 1st August - 31st December   I have created a column in my dat...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI  msommerf 

    Ok, try this way:

    previous phase = 
var _current= CALCULATE(MAX(Dates[Phase Year]),FILTER(Dates,Dates[Phase Selection]="Current Phase")) return
IF(IF(RIGHT(_current,1)="2",LEFT(_current,4)&" Phase 1",VALUE(LEFT(_current,4))-1&" Phase 2")=Dates[Phase Year],"Previous Phase",Dates[Phase Year])

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  msommerf 

Just create a column as below:

previous phase = IF(RIGHT(Dates[Phase Year],1)="2",LEFT(Dates[Phase Year],4)&" Phase 1",VALUE(LEFT(Dates[Phase Year],4))-1&" Phase 2")

 

 

Regards,

Lin

msommerf's avatar
msommerf
Icon for Helper III rankHelper III
6 years ago

hi v-lili6-msft 

 

Many thanks for your response.

 

Your solution works in that it is displaying the previous Phase Year.

I was looking for the column to display the words "Previous Phase" in this column and not display the phase year value.

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    HI  msommerf 

    Ok, try this way:

    previous phase = 
var _current= CALCULATE(MAX(Dates[Phase Year]),FILTER(Dates,Dates[Phase Selection]="Current Phase")) return
IF(IF(RIGHT(_current,1)="2",LEFT(_current,4)&" Phase 1",VALUE(LEFT(_current,4))-1&" Phase 2")=Dates[Phase Year],"Previous Phase",Dates[Phase Year])

     

    Regards,

    Lin

    • msommerf's avatar
      msommerf
      Icon for Helper III rankHelper III
      6 years ago

      v-lili6-msft 

      This is perfect!

      Many thanks for a quick response 🙂