HEEELP with DAX Commands

[Anonymous]

Please Help.

I started using power BI recently and I need help.

i Need to get the ammount of days Left Before our service Expires to put it on a Table. (in Days)

I hace the dates when the client Purchases the service and the Expiration Date of the service, but i need to get the amount of days left before it expires.

Please Help

Thks

[AUaero · Accepted solution]

Assuming your table looks something like this:

Then this measure should work.  If you want to show the days since expiration, just get rid of the switch statement.

# Days Until Expiration = 
VAR TodayDate = UTCTODAY() - 6/24 // 6 indicates the number of hours from UTC (Central Time)
VAR ExpDate = MAX(ExpirationDates[ExpirationDate])

RETURN
SWITCH(
    TRUE(),
    DATEDIFF(TodayDate, ExpDate, DAY) < 0, 0,
    DATEDIFF(TodayDate, ExpDate, DAY)
)

Please accept this a solution if this solves your problem.

[Anonymous]

Thank you so much!

You did it.

eres lo maximo bro!