Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic Forecast slab

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

 

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    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.