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.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous , you can upload your sample data to some cloud storage services like OneDrive, GoogleDrive, Dropbox... make it public and share the link here. Remove sensitive info before sharing.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you for your help