Forum Discussion

zina-aziz's avatar
zina-aziz
Frequent Visitor
8 years ago
Solved

Creating a date filter for a date range

Hi everyone,   I am working with hotel data which contains nightly rates per hotel with a validity date range as follows:   Hotel El Aurassi 180.00 01-Jan-17 31-Dec-17 Epic Sana Luanda ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my solution PBI file from here.

     

    Hope this helps.

     

zina-aziz's avatar
zina-aziz
Frequent Visitor
8 years ago

Thank you. 

 

I am getting this error message. I am not sure what it means.

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

The simple formula in the Query Editor should be:

 

={Number.From([From])..Number.From([To])}

  • zina-aziz's avatar
    zina-aziz
    Frequent Visitor
    8 years ago

    Thank you it is working now.

     

    The calender, is that a table? Also how do i add the month, order and year components underneath it? Are they measures?

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Yes, Calendar is a Table.  To extract the Year and Month from a date, use these calculated column formulas

       

      =YEAR(Calendar[Date])

      =FORMAT(Caledar[Date],"mmmm")

       

      Hope this helps.