Forum Discussion
Possible Tip/Trick: Dynamic Date Dimension Table
I'm going to share the dynamic date dimension table I built, hopefully it is useful to someone! I named it DateTable for this tutorial, and my fact table FactTable. The table is built using the ...
konstantinos : Why would you use a switch and type in all the names, rather than use the format function? Is it a perfromance difference?
RJ : Check out http://community.powerbi.com/t5/Desktop/Transitive-Relationships/m-p/8563#U8563 . It's an interesting concept, and apparently having inactive relationships is fine - the software is still smart enough to filter right through. It wasn't exactly what I ended up using, but that's because I wasn't using a slicer, I wanted a clustered column chart.
ALeef Apologies..SWITCH is slower of course. To be honest I wasn't aware that FORMAT can return months and days due to always importing Date Table..
Thanks, always learning..