Based on multiple if condition then it should sum the two values.

[Anonymous]

version	onboarding plan	app id	No of Feeds	OUTPUT	Modified
4	A_0002	XYZ	2	12	2/1/2024
3	A_0002	XYZ	2		10/1/2023
2	A_0003	XYZ	20		3/5/2024
1	A_0003	XYZ	10	12	2/1/2024

For every record in the file

for each onboarding for this application

{if there are any other onboardings for the same application with modified

date less than or equal to the current onboarding version's modified date

(MDC)

THEN add the feed count of the max(modified date) FCO from that set with

current onboarding version's feed count FCC

end-if

[Anonymous · Accepted solution]

Hi @Anonymous

You seem to want to calculate the "feed" sum based on the maximum modification date that is less than the modification date of the current version.

For your question, here is the method I provided:

Create measures.

Query the maximum modification date that is less than the modification date of the current version.

max modified date = var _max = CALCULATE(MAX('Table'[Modified]), FILTER(ALL('Table'), 'Table'[onboarding plan] = MAX('Table'[onboarding plan])))
RETURN CALCULATE(
    MAX('Table'[Modified]), 
    FILTER(
        ALL('Table'), 
        'Table'[onboarding plan] = MAX('Table'[onboarding plan]) 
        && 
        'Table'[Modified] < _max
        ))

Calculate the sum.

OUT PUT = 
CALCULATE(
    SUM('Table'[No of Feeds]), 
    FILTER(
        ALL('Table'), 
        'Table'[Modified] = [max modified date]
    )
)

Here is the result.

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

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