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 so much Ashish.

 

The solution you have created is exactly what I am after, however I am finding it hard to recreate in my master data file. Would you be generous as to provide me with an explanation of how you achieved it? I am a beginner to Power BI, so a step by step would be much appreciated.

 

Thank you again.

 

Zina

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You are welcone.  I suggest that you go to Home . Edit Queries and look at each of the Applied steps on the right hand side pane.  If you are unclear about any step, please feel free to post back.

  • 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?