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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.