Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to show data from specific date range?

Hello,   I have two groupings  cities names 1 and cities name 2.  And i would like to create a filter for which if date is equal or greater to the  earliest date available in the data source and  b...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous , you can add a calcualted column to create a group.

    Column = IF([Date]<DATE(2021,1,1),[Country group],[City])

    Regards,
    Jing
    If this post helps, please consider Accept it as the solution to help other members find it.

nandic's avatar
nandic
Resident Rockstar
5 years ago

Hi Anonymous ,
Attached demo file. 
My demo file: Main table has columns date, city1, city2, amount. Another table is date table.

VAR _selectedDate =
    SELECTEDVALUE ( 'Table'[Date] )
VAR _City1 = MIN ( Sales[City1] )
VAR _City2 = MIN ( Sales[City2] )
RETURN
    IF ( MIN ( Sales[Date] ) < _selectedDate, _City1, _City2 )

Result:

 

 

Regards,
Nemanja Andic