Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Data Between daterange

I attempted to follow this thread on this channel but I think my issue is easier.   I have the below table (dates) that shows the beginning and ending of a month StartDate EndDate 01/10/202...
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous,

     

    You don't need a table with start and end. You can create just a date table and relate them.

     

    Use a slicer, you are gonna have the start/end dates to filter. Also, you can create more columns on your date table like month/year and use it on slicers.

     

    Check this file: Download PBIX 

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

     

    This is just an example, there are many ways to create the date table.

     

    Ricardo

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Ricardo.

 

What is the best way to create the data table? Do I just press the entre data option in the Home>Data icon?

 

Can you share the steps you did to create this data table. This was what I was trying to ask. Sorry I was not clear.

 

Thanks for those articles I will ingest them 🙂

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

     

     

    This is just an example, there are many ways to create the date table.

     

    Ricardo