Forum Discussion

SPLeon's avatar
SPLeon
Regular Visitor
7 years ago
Solved

Date Slicer with seperate date table

Hi,   I recently started with Power Bi. I made a report in Desktop that presents some sale and buy information. On the page I added a date slicer which can filter the date. Based on the date I wan...
  • themistoklis's avatar
    themistoklis
    7 years ago

    SPLeon

    The workstream on this link will definitely help you to do this.

     

    Make sure on Power Query to use the following formula on the 'Invoke Function' Step.

    Source(#date(2017, 01, 01), Number.From(DateTime.Date(DateTime.LocalNow()) - #date(2017, 01, 01))+1, #duration(1, 0, 0, 0))

     

    You can get the custom calendar from this link.

    Simply copy and paste the Calendar table (Power Query Editor) from the Calendar PowerBI workspace to your PowerBI workspace

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

SPLeon

The workstream on this link will definitely help you to do this.

 

Make sure on Power Query to use the following formula on the 'Invoke Function' Step.

Source(#date(2017, 01, 01), Number.From(DateTime.Date(DateTime.LocalNow()) - #date(2017, 01, 01))+1, #duration(1, 0, 0, 0))

 

You can get the custom calendar from this link.

Simply copy and paste the Calendar table (Power Query Editor) from the Calendar PowerBI workspace to your PowerBI workspace

 

SPLeon's avatar
SPLeon
Regular Visitor
7 years ago

I found another solution. It is a template which contains a date table.

Here you can specifiy the start date. The end date is the today's date. 

 

Many thanks.

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi SPLeon,

     

    It seems that you have found the solution, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

    Best  Regards,

    Cherry