Forum Discussion

milson4's avatar
milson4
New Member
1 year ago
Solved

Cumulative calculation does not show months/weeks without imput

Situation: I have a data table: Reports, containing issued date, report no. etc.,,. DateTable contains all dates from beginning of the year till end of the year. Problem: Calculation: IssuedRepo...
  • v-priyankata's avatar
    1 year ago

    Hi milson4 

    Thank you for reaching out to Microsoft Fabric Community.

    please try below DAX it may helps you.

     

    IssuedReportsCumulated = 
    VAR MaxDate = MAX('DateTable'[IssuedDate])
    VAR LastReportDate = 
        CALCULATE(
            MAX('Reports'[IssuedDate]),
            'Reports'[IssuedDate] <= MaxDate,
            ALL('DateTable')
        )
    RETURN
    CALCULATE(
        [IssuedReports],
        FILTER(
            ALL('DateTable'),
            'DateTable'[IssuedDate] <= LastReportDate
        )
    )


    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.

  • v-priyankata's avatar
    1 year ago

    Hi milson4 

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.