Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datediff folder using today() and a date on a table

I have created a DAX query provide me with the difference between today() and an expiry date. The expiry date is on a table and differs with each row. This is my query:-  DaystoExpiry = DATEDIFF(to...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    is it meausre or column?

     

    if it is column remove distinct else replace distinct with max or selectedvalue.

     

    measure DaystoExpiry = DATEDIFF(today(),Selectedvalue('transactiondiscount'[Expiry_Date]),day)

     

    Column DaystoExpiry = DATEDIFF(today(),'transactiondiscount'[Expiry_Date],day)

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

is it meausre or column?

 

if it is column remove distinct else replace distinct with max or selectedvalue.

 

measure DaystoExpiry = DATEDIFF(today(),Selectedvalue('transactiondiscount'[Expiry_Date]),day)

 

Column DaystoExpiry = DATEDIFF(today(),'transactiondiscount'[Expiry_Date],day)

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Nice!!

     

    I had it as a measure. Made the suggested changes and it worked.

    Kudos to you!