Forum Discussion
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(today(),DISTINCT('transactiondiscount'[Expiry_Date]),day)
That formula does not produce an error when I commit the formula. But breaks my table visual when I add it to the visual.
Is there a problem with my formula? Can it be imporoved?
Edited:
Ok, so I get this message from the visual
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.
2 Replies
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.