Forum Discussion

rodbeck's avatar
rodbeck
New Member
8 years ago
Solved

Date slicer field

Hi, I have a built a simple reporting from an Excel action log.   The goal was to copile a monthly reproting with - A chart displaying late actions versus non late actions - A table displaying a...
  • Abduvali's avatar
    Abduvali
    8 years ago

    Hi @Rovand,

     

    All you need to do is to create date table in Power BI or use the one exported from excel. Just create a relationship between 2 date fields, see link below to my library where you can download the solution.

    Follow the link: Network-days

     

    Table relationshipDate TableSelecting none existing date

    Hope this will help.

     

     

    Regards

    Abduvali

     

     

Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Hi @Rovand,

 

All you need to do is to create date table in Power BI or use the one exported from excel. Just create a relationship between 2 date fields, see link below to my library where you can download the solution.

Follow the link: Network-days

 

Table relationshipDate TableSelecting none existing date

Hope this will help.

 

 

Regards

Abduvali

 

 

  • rodbeck's avatar
    rodbeck
    New Member
    8 years ago

    That worked, the only thing I changed was the relationship that was many to one as multiple actions can have the same start or end date.

     

    Thanks a lot !