Forum Discussion

cpoojan's avatar
cpoojan
Regular Visitor
5 years ago
Solved

How to return value from CROSSJOIN

Hi All BI Expert.         I'm working on generating a system usage report. There are 2 table  1. M_User table is a master table for all user 2. Log table is a report that shows the number of peopl...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    cpoojan 

    Create a table named "Usage" from the New Table option as follows:


    Add the Fields to a table visual fro the Usage table and create the following measure:

    Measure = 
IF( 
    CONTAINS('Log','Log'[EmpID],MAX(Usage[Emp ID]),'Log'[LoginDate],MAX(Usage[LoginDate])),
    "Yes",
    "No"
)

    Result

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

cpoojan 

Create a table named "Usage" from the New Table option as follows:


Add the Fields to a table visual fro the Usage table and create the following measure:

Measure = 
IF( 
    CONTAINS('Log','Log'[EmpID],MAX(Usage[Emp ID]),'Log'[LoginDate],MAX(Usage[LoginDate])),
    "Yes",
    "No"
)

Result

 

 

cpoojan's avatar
cpoojan
Regular Visitor
5 years ago

Thank you so much. Let me try.