Selectedvalue and calculated columns

Birthe — Mon, 31 Jul 2023 15:14:30 GMT

I have been struggling all day now. Can someone please help me?

To simplify, I have a table (+1000 records) with contracts, all having a start and an end date:

Contractnr	ContractFrom (date)	ContractUntil (date)
1	01/01/2010	05/06/2023
2	05/04/2023	04/03/2028

I also have a date table 'Date'[date] , linked to other significant information.

As a result, I want to select one of the dates in my date table, and show how many contracts are valid for that given date.

As a first step, I was trying the following but it does not work

I wanted an extra column in the contracts table above with formula:

DateBetween = IF(

AND (

'Contracts'[ContractFrom] <= SELECTEDVALUE('Date'[Date]),

'Contracts'[ContractUntil] >= SELECTEDVALUE('Date'[Date])

"Yes",

"No")

This does not give the expected result. Can somebody help me?

Thank you very much! Birthe

Re: Selectedvalue and calculated columns

ERD — Mon, 31 Jul 2023 16:06:03 GMT

Birthe ,

You can try this measure:

DateBetween = VAR _from = SELECTEDVALUE ( 'Table'[ContractFrom] ) VAR _to = SELECTEDVALUE ( 'Table'[ContractUntil)] ) VAR _date = SELECTEDVALUE ( 'Date'[Date] ) RETURN IF ( _date >= _from && _date <= _to, 1, 0 )

Re: Selectedvalue and calculated columns

Birthe — Tue, 01 Aug 2023 07:03:05 GMT

Thank you so much ERD!

topic Re: Selectedvalue and calculated columns in DAX Commands and Tips

Selectedvalue and calculated columns

Re: Selectedvalue and calculated columns

Re: Selectedvalue and calculated columns