Sunday, 13 September 2015

Table Calculations Adressing Options

Table Calculations are computations that are applied to the values in the entire table and are
often dependent on the table structure itself.

The most important factor in the Table Calculations are addressing and partitioning options.Addressing can be relative to the table structure (options beginning with Table, Pane, or Cell)
or to a specific field (such as Category, Order Date, or Region). 
Addressing options based on table structure.

The Different addressing options available are

1)Table Across:-
If we performs the computation across the Table horizontally,then such a kind of addressing is known as Table Across.




2)Table Down:-
If we performs the computation down the Table vertically,then such a kind of addressing is known as Table Down.

3)Table Across then Down:-
If we performs the computation across the Table horizontally then Down the table vertically, such a kind of addressing is known as Table Across then down.


4)Pane Across:-
If we performs the computation across the Pane horizontally,then such a kind of addressing is known as Pane Across.



5)Pane Down:-
If we performs the computation down the pane vertically,then such a kind of addressing is known as Pane Down.



6)Pane Across then Down:-
If we performs the computation across the pane horizontally then down the pane vertically,then such a kind of addressing is known as Pane Across then Down.




7)Cell:-
If we performs the computations at each and every value level,then such a kind of addressing is known as Cell.


Thanks Guru's,
Prazval.ks














DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks