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])

amitchandak's avatar
amitchandak
Super User
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])