Forum Discussion
pstanek
Post Patron
Post PatronDate - 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.
pstanekPost Patron
Post PatronI 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.
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.
- pstanek
I use single -(Direction 1 to N) most of time. but I cannot see how it can influcence slicer, Because it use only one parameter.