Friday 18 March 2016

Nested Table Calculations behaviour

A nested table calc is when one table calc is used inside another table calc, which is different from writing a calculation that uses two table calculation functions independently.  This is an important distinction because a nested table calc will allow you to compute the parent table calc separately from the child table calc, whereas a calculation containing two independent table calculation functions will act as a single table calc when determining how to compute the table calc,

In the Below Example,we are having two table calculations
1)Lookup   2)Index
While addressing  we need to set adressing Options individually for both the functions.



Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks