Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 date table to work out and display the Current Phase so this can be used in a slicer using:
Solved! Go to Solution.
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
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
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.
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
Hi @msommerf ,
Create a caluclated column as follows:
Thank you for your quick response.
I have created a calculated column using your DAX formula as follows:
Regards
Mark.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |