Forum Discussion

pstanek's avatar
pstanek
Post Patron
8 years ago

Date - too slow calculation

Hi, I have column with date format,  because of that reports are too slow.

 

I created two slicers from that column, but  It has to calculate it from milions rows, that delays report calculation.

Need Help
Show and Tell

8 Replies

  • BeemsC's avatar
    BeemsC
    Resolver III
    8 years ago

    This is probably a performance issue.
    If you are not using a lot of the dates, it might be an idea to filter them out

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi pstanek,

     

    If you only use certain dates for the dashboard you are trying to create, it is maybe better to filter them out in the "Query Editor" than to try to filter them out with a slicer.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      The number of rows should not cause that kind of performance issue. Do you have relationships between tables with "Both" as the direction?

    • pstanek's avatar
      pstanek
      Post Patron
      8 years ago

      I  only create report in power Bi for others, so I use no additional slicer in Query Editor. Problem is that calculated column

      Year=YEAR('Table'[Date]) ,Month=MONTH('Table'[Date])  are too slow ,when I have Slicers Year, Month. 

      It calculates so long only to say we have months 1-12. It should se useful to have calendar in power bi.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I don't see any reason why those columns would make anything slow. I use columns just like that. I'm certain the problem is something else. You didn't answer my question about table relationships.