Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using 2 Date Fields as One Slicer

Hi,   I have a table of Opportunities. In there I have 2 columns - "CreatedOn" And "ClosedOn".   I have a Card containing count of new opportunities created (Ideally Controlled by "CreatedOn"), a...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may create the measures as below:

    Opportunities Created =
IF (
    ISFILTERED ( 'Calendar'[YearMonth] ),
    CALCULATE (
        COUNT ( Table1[Opportunities] ),
        FILTER ( Table1, Table1[Create] IN VALUES ( 'Calendar'[YearMonth] ) )
    )
)

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may create the measures as below:

Opportunities Created =
IF (
    ISFILTERED ( 'Calendar'[YearMonth] ),
    CALCULATE (
        COUNT ( Table1[Opportunities] ),
        FILTER ( Table1, Table1[Create] IN VALUES ( 'Calendar'[YearMonth] ) )
    )
)

Regards,

Cherie

Thomasdu43's avatar
Thomasdu43
New Member
7 years ago

Hello Cherie,

 

I used your solution and it is effective.

 

However, if some fieds are places I want to represent on a map, how should I do so that places and dates related?

 

Thank you and regards.