Get Field

[Vittore8]

Hi, how can I get this result using set analysis:

<Date={2019}> -- only by year

result:

01.01.2019
01.02.2019

[Vegar · Accepted solution]

Use a set expression like this:

{<[Date] = {">=$(=makedate(2019))<$(=makedate(2020))"}>}

IF you want to create a dimension then use it in an expression like this: 

=aggr(only({<[Date] = {">=$(=makedate(2019))<$(=makedate(2020))"}>}[Date]), [Date])

IF you want to use it in a measure then use an expression like this:

=sum({<[Date] = {">=$(=makedate(2019))<$(=makedate(2020))"}>}[Amount])