Forum Discussion

ALeef's avatar
ALeef
Resolver II
10 years ago

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 ...
Tips and Tricks
konstantinos's avatar
konstantinos
Memorable Member
10 years ago

ALeef Great Job..Only needs a SWITCH for the month names and set...

RJ You can create a second Calendar or use the same with inactive relantionship & USERELANTIONSHIP.

  • ALeef's avatar
    ALeef
    Resolver II
    10 years ago

    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.

    • konstantinos's avatar
      konstantinos
      Memorable Member
      10 years ago

      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..