create a measure of time that subtracts a date field with the today function

[ALOPEZ]

hello forum

I have a Billing table that includes a billing date field. I need to calculate a measure that subtracts the billing date field using the today() function to calculate the number of days since it was billed.

I tried to do this but it gives me an error because it expects the field to have a single value.

The code of measure with error:

Dias =

VAR VENCIMIENTO = CUEN_M01[FECHA_VENC]

VAR HOY = TODAY()

VAR _RESULT = HOY-VENCIMIENTO

RETUNR

_RESULT

Thak you

[pranit828 · Accepted solution]

Hi @ALOPEZ ,
Please try...

Dias =

VAR VENCIMIENTO = SELECTEDVALUE(CUEN_M01[FECHA_VENC])

VAR HOY = TODAY()

VAR _RESULT = HOY-VENCIMIENTO

RETURN

_RESULT

[Bmejia · Accepted solution]

Can also use the function DATEDIFF

Datediff = SUMX('CUEN_M01', DATEDIFF(CUEN_M01[FECHA_VENC], TODAY() ,DAY))

[pranit828 · Accepted solution]

Hi @ALOPEZ ,
Please try...

Dias =

VAR VENCIMIENTO = SELECTEDVALUE(CUEN_M01[FECHA_VENC])

VAR HOY = TODAY()

VAR _RESULT = HOY-VENCIMIENTO

RETURN

_RESULT