It won't let me subtract two dates

[Syndicate_Admin]

Good.

I'm trying to subtract two dates, but I can't, since when creating the measure it doesn't show me the date fields of the table I need, my measurement would be:

difference = DATEDIFF( Contracts[FROM]:, Dcontratos[UNTIL], DAY)

In the following screenshot you can see how I have defined the dates:

Format

when creating the measure I do not see the from field:

Structure and representation

What's wrong?

Thanks a lot.

[Anonymous]

@Syndicate_Admin In DATEDIFF function you have to use single value dates instead of date columns. Use variable to define start/end dates and then use them in the function.

[Syndicate_Admin]

Good you mean this:

I put it like that, but it still doesn't leave me.

[Anonymous · Accepted solution]

@Syndicate_Admin No, I mean something like this:

diff_measure=var startDate=MIN([DESDE:])

var endDate=MAX([HASTA:])

return DATEDIFF(startDate,endDate,DAY)

Variables startDate and endDate you can define in any other way. But using variables you doesn't need DATEDIFF function to substract two dates, you can just substract those variables:

diff_measure=var startDate=MIN([DESDE:])

var endDate=MAX([HASTA:])

return endDate-startDate

[Syndicate_Admin]

Hello my problem is when choosing the format of the measurement data. It doesn't let me choose more than dates. No numbers, can you help me?

[Syndicate_Admin]

Resolved with Convert (Date, Integer)

[Syndicate_Admin]

OK, with the alegro.

[Syndicate_Admin]

Have you tried to change the data type to number, from Power Query?

[Syndicate_Admin]

Thank you very much, it has worked for me, I have finally used the today in Star to calculate today.

Greetings

[Anonymous]

@Syndicate_Admin Then you can accept my response as a solution)

[Syndicate_Admin]

It is already accepted.

Greetings