Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

how to correctly add columns from a table visual?

Hello, I want to do a calculated table, because I have problems with circular dependencies. Sample table: The shipping table:  OrderNo.   Date    Status    Sales   Position 1111   ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Applicable88 ,

     

    Check the formula.

    Calculated Table =
    Var _CurrentDate =
    Max ( ShippingTable[Date] )
    Var _LatestPreparationDate =
    Calculate (
    Max ( PreparationTable[Date] ),
    PreparationTable[Date] < _CurrentDate
    )
    Var _Orders_S =
    Calculatetable (
    Values ( ShippingTable[OrderNo] ) ,
    ShippingTable[Status] = "S",
    PreparationTable[Date] = _LatestPreparationDate
    )
    Var _Orders_P =
    Calculatetable (
    Values ( PreparationTable[OrderNo] ) ,
    PreparationTable[Status] = "P"
    )
    var _except = FILTER(ShippingTable, ShippingTable[OrderNo] in EXCEPT(_Orders_S,_Orders_P))
    return
    SUMMARIZE(_except,[Date],"sale",SUM(ShippingTable[Sales]),"position",SUM(ShippingTable[Position]),"_count",DISTINCTCOUNT(ShippingTable[OrderNo]))
     
    Best Regards,
    Jay
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Applicable88 , A measure like

Calculate ( Countrows (except( ShippingTable[OrderNo] , OrderTable[OrderNo] ) ) )

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago

amitchandak , sorry, but thats not going to add the columns that I need.