Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello Folks,
I need your help on creating a new column (Status) where if the Date Difference column has given below values then the new column (Status) should consist of these values:
If 8 then "1 Week"
If 175 then "6 months"
If 300 the "7 months"
If 120 then "4 months"
If 90 then "3 months"
However, if the Date Difference has blank value then lookup in the Result column where if its "Not Started" then new_status column should be "Not Started" otherwise "Date Not Found"
Have a look at the image below:
Thanks in Advance!
Solved! Go to Solution.
Hi @Anonymous
Create a calculated column like this :
New Status = SWITCH(TRUE(),'Table'[Date Difference]=8,"1 week",'Table'[Date Difference]=175,"6 months",'Table'[Date Difference]=300,"7 months",'Table'[Date Difference]=120,"4 months",'Table'[Date Difference]=90,"3 months",'Table'[Date Difference]=BLANK() && 'Table'[Result]="Not Started","Not Started","Date Not Found")
The result is as shown :
I have attached my pbix file ,you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Create a calculated column like this :
New Status = SWITCH(TRUE(),'Table'[Date Difference]=8,"1 week",'Table'[Date Difference]=175,"6 months",'Table'[Date Difference]=300,"7 months",'Table'[Date Difference]=120,"4 months",'Table'[Date Difference]=90,"3 months",'Table'[Date Difference]=BLANK() && 'Table'[Result]="Not Started","Not Started","Date Not Found")
The result is as shown :
I have attached my pbix file ,you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , A new column like this
Switch( True(),
[result] = "Not Started" , "Not Started"
[result] <> "Not Started", isblank([Date Difference]) , "Date not Found"
[Date Difference] < 8, "1 Week",
[Date Difference] < 175 , "6 months",
// Add others
, "Other"
)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.