Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show

HiTeam,   I am having the data with the columns like Date and amount .   We are plotted column chart with two values (Current year amt and Previous amt).    Requirement: 1. Current year amount...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Example with date table

    Year behind amount= CALCULATE(SUM(Sales[Amount]),dateadd('Date'[Date],-1,Year))

    Amount =SUM(Sales[Amount]) //this year amount

    measure  =

    if(max(Date[Date]) <=today(), [Amount], [Year behind amount])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

Could you please provide some sample data (exclude sensitive data) and the formula of [PY_Amount] and [CY_Amount] if they are measure or calculated column in order to find the problem cause and provide a suitable solution? Thank you.

In addition, please review the following threads and check whether they can help you resolve the problem.

Comparing this year and last year measure on a bar chart

How to compare Last year and Current Year sales in Power BI?

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