Time Intelligence Functions (DAX)

pstanek Here is a thread which describes how to create a dynamic data table in PBI. It is a table that relates to a date in your fact table, and allows you to filter on other date parts (YR, MO, etc).

http://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/td-p/8462

 There are numerous other examples out there.