Dynamic Forecast slab

[TS08]

Hi, I was trying to create a Slab on the basis of Forecast Date and Today() for all the oreders created till date.

I have created a dax but it is not giving me desired result... please check below dax and out put screen shot: -

Forecast_Slab2 =

if(ISBLANK(sfdc[Delivery Forecasted Date]), "No Target",

if(sfdc[Delivery Forecasted Date]< TODAY(), "1) Target Missed",

if(MONTH(sfdc[Delivery Forecasted Date]) = MONTH(today()), "2) " & LEFT(Format(sfdc[Delivery Forecasted Date], "MMM"), 3) & " " & RIGHT(year(sfdc[Delivery Forecasted Date]), 2),

if((month(sfdc[Delivery Forecasted Date]) - MONTH(today()) = 1 || month(sfdc[Delivery Forecasted Date]) - MONTH(today()) = -11), "3) " & LEFT(format(sfdc[Delivery Forecasted Date], "MMM"), 3) & " " & RIGHT(year(sfdc[Delivery Forecasted Date]), 2),

if((MONTH(sfdc[Delivery Forecasted Date]) - MONTH(today()) = 2 || month(sfdc[Delivery Forecasted Date]) - MONTH(today()) = -10), "4) " & LEFT(format(sfdc[Delivery Forecasted Date], "MMM"), 3) & " " & RIGHT(year(sfdc[Delivery Forecasted Date]), 2), "5) > 3 Months")))))

Now the output is not as per the expecation. All these below highlighted results should be part of ">3Months": -

Thanks

TS

[v-rongtiep-msft]

Hi @TS08 ,

There is nothing wrong  with the formula. Could you please provide your pbix file without privacy information and your desired output with more details?

Although you have provide a screenshot, the screenshot cannot find the sfdc[Delivery Forecasted Date] column.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.