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 

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 🙂