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 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.