Calculated Column

[Shubhamj17]

Hello team,

I have got a query, how do I create a new column with a condition which satisfies the below condition:

Suppose a new Trainee named Shubham Jain (Manager is Jackie Shroff) signs up for Acroyoga. Another trainee named Jeff Bezos (manager is Jackie Shroff) signs up for Alternate history. In that case, I want to count Jackie Shroff as 1 only since both people who signed up are his associates only, so how do we create a calculated column or a new measure which satisfies this condition?  

I cannot crack this and I know only you can pull me out of this.

Hobbies	Trainee	Manager
3D printing	Ajit Wadekar	J. P. Chandrababu
Acroyoga	S. Venkataraghavan	J. V. Somayajulu
Acting	Bishan Singh Bedi	Jaaved Jaffrey
Alternate history	Sunil Gavaskar	Jackie Shroff
Amateur radio	Gundappa Viswanath	Jackky Bhagnani
3D printing	Kapil Dev	Jagadish
Acroyoga	Syed Kirmani	Jagapati Babu
Acting	Mohinder Amarnath	Jagathy Sreekumar
Alternate history	Ravi Shastri	Jagdeep
Amateur radio	Dilip Vengsarkar	Jagdish Raj
Beatboxing	Krishnamachari Srikkanth	J. P. Chandrababu
Beer tasting	Mohammad Azharuddin	J. V. Somayajulu
Bell ringing	Sachin Tendulkar	Jaaved Jaffrey
Binge watching	Ajay Jadeja	Jackie Shroff
Beatboxing	Sourav Ganguly	Jackky Bhagnani
Beer tasting	Rahul Dravid	Jagadish
Bell ringing	Anil Kumble	Jagapati Babu
Binge watching	Virender Sehwag	Jagathy Sreekumar
Board/tabletop games	M.S. Dhoni	Jagdeep
Book discussion clubs	Suresh Raina	Jagdish Raj
Book restoration	Gautam Gambhir	J. P. Chandrababu
Bowling	Virat Kohli	J. V. Somayajulu
Board/tabletop games	Ajinkya Rahane	Jaaved Jaffrey
Book discussion clubs	Rohit Sharma	Jackie Shroff
Book restoration	Shikhar Dhawan	Jackky Bhagnani
Bowling	KL Rahul	Jagadish

Please pull me out of this.

@amitchandak @Greg_Deckler @parry2k @lbendlin @MFelix @Ashish_Mathur @ImkeF @Zubair_Muhammad @Jihwan_Kim @GilbertQ 

[SamInogic · Accepted solution]

Hi,

We are a bit Unclear about your Calculated column.

However, as per our understanding, you are looking for a calculated Column that will give a count of 1 if both people signed in were his associates,

This is what I have found,

Initially, you have to create a Custom Column For Index from Power Query,

Then create a Calculated column for the manager using the below Dax Expression,

Previous row Manager =
LOOKUPVALUE('Table
(5)'[Manager],'Table
(5)'[Index],'Table
(5)'[Index]-1)

Finally, create the Result Calculated Column using the below Dax Expression,

Result =
IF('Table
(5)'[Manager] =
'Table (5)'[Previous row Manager],1,0)

Since both are recently signed-in trainees, the manager is Jackie Shroff hence two rows have the same Cell value, which can be compared to the Previous row Manager to check if the Manager is the same or not,

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[Ashish_Mathur · Accepted solution]

Hi,

Based on the data that you have shared, show the exact result you are expecting.  If you want a card visual, then what exact number should appear in that card.  If a Table, visual, then what should be dragged to the rows and what result do you want to see in the first 2/3 rows.

[SamInogic · Accepted solution]

Hi,

We are a bit Unclear about your Calculated column.

However, as per our understanding, you are looking for a calculated Column that will give a count of 1 if both people signed in were his associates,

This is what I have found,

Initially, you have to create a Custom Column For Index from Power Query,

Then create a Calculated column for the manager using the below Dax Expression,

Previous row Manager =
LOOKUPVALUE('Table
(5)'[Manager],'Table
(5)'[Index],'Table
(5)'[Index]-1)

Finally, create the Result Calculated Column using the below Dax Expression,

Result =
IF('Table
(5)'[Manager] =
'Table (5)'[Previous row Manager],1,0)

Since both are recently signed-in trainees, the manager is Jackie Shroff hence two rows have the same Cell value, which can be compared to the Previous row Manager to check if the Manager is the same or not,

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/