Billing items

[Supermat]

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

[v-angzheng-msft · Accepted solution]

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.

[ryan_mayu]

@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.