Forum Discussion

Supermat's avatar
Supermat
Helper I
5 years ago
Solved

Billing items

Hi,

I really don't know how to solve this problem: I have a table with costumers orders and there's not a flag that tell me how many items are delivered. I only know that (in this example), for order 21003130 there are 3 pieces that model 930001.337 and two of them was shipped how can i put in my report that only last row is active?

 

Thx in advance



Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Supermat 

     

    Create a measure that compares the delivery date to today, and if it is greater than today, it is active.

     

    _ac =
IF ( MAX ( 'Table'[SBDAT] ) > TODAY (), 1, 0 )

     

    Create a measure to count the active status.

     

    _Activate_count =
CALCULATE ( COUNT ( 'Table'[SBDAT] ), FILTER ( 'Table', 'Table'[_ac] = 1 ) )

     

    Another measure can be created to apply conditional formatting to the field so that the active date is highlighted.

     

    _color = IF([_ac]=1,"pink")

     

    result:

    Please refer to the attachment below for details. Hope this helps.

    If I don't understand you correctly, please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    Supermat 

    i think you need to create a shipped table. Then combine two table to get those rows that are not found in shipped table. those rows are active.

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, Supermat 

     

    Create a measure that compares the delivery date to today, and if it is greater than today, it is active.

     

    _ac =
IF ( MAX ( 'Table'[SBDAT] ) > TODAY (), 1, 0 )

     

    Create a measure to count the active status.

     

    _Activate_count =
CALCULATE ( COUNT ( 'Table'[SBDAT] ), FILTER ( 'Table', 'Table'[_ac] = 1 ) )

     

    Another measure can be created to apply conditional formatting to the field so that the active date is highlighted.

     

    _color = IF([_ac]=1,"pink")

     

    result:

    Please refer to the attachment below for details. Hope this helps.

    If I don't understand you correctly, please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.