Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IF statement issue

I have a data that provides values of sales for 2 years but on quarterly basis, Example:  Year Quarter Sales 2020 Q1 50 2020 Q2 30 2020 Q3 40 2020 Q4 50 2021 Q1 60 2...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , With Time intelligence, create QTD and YTD and table a diff

     

    example

    QTD= CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

    YTD= CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

     

     

    Till Last Qtr = [YTD] -[QTD]

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , With Time intelligence, create QTD and YTD and table a diff

 

example

QTD= CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

YTD= CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

 

 

Till Last Qtr = [YTD] -[QTD]