How to change date in table?

[GAURAV7781]

In below image Calculation is my field in which some dax is used, This is planning report which I am developing BI,

As of now my dax is using Today() function, based on that calculation is working, But  Because of daily planning he want to change dates,

Can I chage current date in formation table by using slicer, Please help

Calcuation =

IF(('Table'[Days Lead Time to Vendor]+'Table'[Safety Stock No Of Days])>30,('Table'[Days Lead Time to Vendor]+'Table'[Safety Stock No Of Days])+TODAY(),30+TODAY())

What can i write to resolve? 

This is planning report so user wants to plan by entering different date

[parry2k]

@GAURAV7781 so you trying that use select a date and use that date instead of today(), correct?

[GAURAV7781]

@parry2k  Yes Sir, I want this 

[v-piga-msft]

Hi @GAURAV7781 ,

Please replace Today() function with SELECTEDVALUE('Table'[Date column]).

And the 'Table'[Date column] should be the column which you created as date slicer.

Best  Regards,

Cherry

[GAURAV7781]

Dear @v-piga-msft  https://photos.app.goo.gl/LeerZ9jWJFx5nMtE6After writing this its is making wrong calculation, & dat...

As per above given solution, 

[v-piga-msft]

Hi @GAURAV7781 ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[GAURAV7781]

@v-piga-msft 

 Please check data set

https://drive.google.com/open?id=1CTnw08hqZAu3FoA4KGXIB5xYiKTXiBpJ

[v-piga-msft · Accepted solution]

Hi @GAURAV7781 ,

By testing with your pbix, you could create the measure like below.

In addition, please note that do not create the relationship between the two tables.

Calcuation_ =
IF (
    (
        MAX ( 'Table'[Days Lead Time to Vendor] )
            + MAX ( 'Table'[Safety Stock No Of Days] )
    ) > 30,
    MAX ( 'Table'[Days Lead Time to Vendor] )
        + MAX ( 'Table'[Safety Stock No Of Days] )
        + SELECTEDVALUE ( 'Calender'[Date] ),
    30 + ( SELECTEDVALUE ( Calender[Date] ) )
)

Here is the output.

Best Regards,

Cherry

[GAURAV7781]

thankyou so much sir

---

@v-piga-msft wrote:

Hi @GAURAV7781 ,

By testing with your pbix, you could create the measure like below.

In addition, please note that do not create the relationship between the two tables.

Calcuation_ =
IF (
    (
        MAX ( 'Table'[Days Lead Time to Vendor] )
            + MAX ( 'Table'[Safety Stock No Of Days] )
    ) > 30,
    MAX ( 'Table'[Days Lead Time to Vendor] )
        + MAX ( 'Table'[Safety Stock No Of Days] )
        + SELECTEDVALUE ( 'Calender'[Date] ),
    30 + ( SELECTEDVALUE ( Calender[Date] ) )
)

Here is the output.

Best Regards,

Cherry

---

[v-piga-msft]

Hi @GAURAV7781 ,

I'm afraid that you should create with measure rather than calculated column.

If it is convenient, could you share your data sample and desired output so that we could help further on it?

Best  Regards,

Cherry

[GAURAV7781]

@v-piga-msft Dear sir,

In power Query it is making alll dates wrongI created relation ship of slicer with the dateIn slicer if nothing is selectedIf i choose, It is not showing, I want if i choose date my calculation should change accordingly