Forum Discussion

Vijayashree9820's avatar
Vijayashree9820
Regular Visitor
2 years ago
Solved

Cumulative Values

CumulativeCurrentYearSales =
CALCULATE (
    View_SalesRevenue[Sales Amount MC],
    FILTER (
        ALL (View_SalesRevenue[RevenueDate]),
        YEAR ( View_SalesRevenue[RevenueDate] ) = YEAR ( TODAY () )
            && View_SalesRevenue[RevenueDate] <= MAX ( View_SalesRevenue[RevenueDate] )
))
 
in this measure values are coming same for measure its not coming out like cumulative and I have to set values a cu
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Vijayashree9820 ,

    Please update the formula of measure [CumulativeCurrentYearSales ] as below and check if it can return the expected result...

    CumulativeCurrentYearSales =
CALCULATE (
    View_SalesRevenue[Sales Amount MC],
    FILTER (
        ALLSELECTED ( View_SalesRevenue ),
        YEAR ( View_SalesRevenue[RevenueDate] ) = YEAR ( TODAY () )
            && View_SalesRevenue[RevenueDate]
                <= SELECTEDVALUE ( View_SalesRevenue[RevenueDate] )
    )
)

    In addition, you can refer the following links to get the culmulative values...

    Cumulative Total/ Running Total in Power BI - Power BI Docs

    Power BI Blog: Calculating Cumulative Totals for Time Periods 

     

    If the above ones can't help you get the expected result, please provide some sample data in your table 'View_SalesRevenue' (exclude sensitive data) with Text format and your expected result with special examples and screenshots. Later I will check if there is any workaround to achieve your requirement. You can refer the following link to share the required info:

    How to provide sample data in the Power BI Forum

     

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Vijayashree9820 

    Can you please try below DAX

     

    CumulativeCurrentYearSales =
CALCULATE (
    View_SalesRevenue[Sales Amount MC],
    FILTER (
        ALL (View_SalesRevenue[RevenueDate]),
            && View_SalesRevenue[RevenueDate] <= MAX ( View_SalesRevenue[RevenueDate] )
))

     


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Vijayashree9820 ,

    Please update the formula of measure [CumulativeCurrentYearSales ] as below and check if it can return the expected result...

    CumulativeCurrentYearSales =
CALCULATE (
    View_SalesRevenue[Sales Amount MC],
    FILTER (
        ALLSELECTED ( View_SalesRevenue ),
        YEAR ( View_SalesRevenue[RevenueDate] ) = YEAR ( TODAY () )
            && View_SalesRevenue[RevenueDate]
                <= SELECTEDVALUE ( View_SalesRevenue[RevenueDate] )
    )
)

    In addition, you can refer the following links to get the culmulative values...

    Cumulative Total/ Running Total in Power BI - Power BI Docs

    Power BI Blog: Calculating Cumulative Totals for Time Periods 

     

    If the above ones can't help you get the expected result, please provide some sample data in your table 'View_SalesRevenue' (exclude sensitive data) with Text format and your expected result with special examples and screenshots. Later I will check if there is any workaround to achieve your requirement. You can refer the following link to share the required info:

    How to provide sample data in the Power BI Forum

     

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards