need to display a message based on strtdate and enddate

[Anonymous]

Hi Team,

need to display a message based on strtdate and enddate for 30 days from current date,if enddate is greterthan today need to show on cloumn(shot desc) otherwise need to display "No Maintenance" and if table is blank also need to display "No Maintenance".

strtdate           enddate          shortdesc

01/06/2020   10/06/200        bw maintenance

above case we need to display "bw mantenace"

strtdate           enddate          shortdesc

01/06/2020   5/06/200        bw maintenance

above case we need to display "No mantenace"

strtdate           enddate          shortdesc

need to display "No mantenace"

Regards,

Ravi

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, you may create a measure as below.

Desc1 = 
IF(
    COUNTROWS(Table1)>0,
    IF(
        SELECTEDVALUE(Table1[enddate])>=TODAY()+30,
        "bw mantenace",
        "No mantenace"
    ),
    "No mantenace"
)

Result:

Best Regards

Allan

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

[amitchandak]

@Anonymous , try a new column like

new column = if([start Date]<= today()+30 && [end Date]<= today()+30 && [End Date]> Today(),"bw maintenance","No mantenace")

Do any changes you need

[Anonymous]

Thanks for the response.

if table is blank need to display no maintenance but you logic aslo giving blank .

 if we have two entries in table one is outdated and one is with in thirty days with your logic we are getting two values one is no maintenance and another bw maintenance ,Need to display only current one .