Thursday, 24 March 2016

Creating a Calendar with NO Calculations


1. Right click on the date field and duplicate it
2. Drag Date to Columns, choose M/Y as format
3. Drag Date to Rows, choose Week as format




4. Drag Date to Columns, choose Weekday as format
5. Drag Date to Rows, choose Week as format

6. Change Mark type to Square 


7.Right click-drag Date (Copy) to Columns, choose Weekday as format
8.Right click-drag Date (Copy) to Rows, choose Week as format
9.Filter to a single month
10.Increase the size of the squares until they fill the grid
11.Uncheck “Show Header” on all pills except MY(Date) and resize the view so the grid is made up of squares.
12.Format as desired
13.Expected Results as below:-



Thanks Guru's,
Prazval.ks


DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks