CROSSFILTER HELP NEEDED

Hi Anonymous ,

I create two tables as you mentioned and make a relationship between them.

Then I think you can use this DAX code.

Measure = 
VAR MD = MAX('Inventory Transactions'[D_Date_SID])
RETURN
CALCULATE(
    FORMAT(
        DATE(
            LEFT(MD, 4),            
            MID(MD, 5, 2),        
            RIGHT(MD, 2)            
        ),
        "yyyy/mm/dd"
    ),
    'Inventory Transaction Type'[Inventory Transaction Type Code] = 0,
    CROSSFILTER(
        'Inventory Transaction Type'[D_Enum_InventoryTransactionType_SID],
        'Inventory Transactions'[D_Enum_InventoryTransactionType_SID],
        BOTH
    )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.