Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Day YoY measure

Hi PBI Community -  I'm creating a dashboard with YTD, MTD, WTD and current day, I'm having an issue with the Daily YoY % change. The values are blank... any help would be appreciated, below are the...
  • amitchandak's avatar
    6 years ago

    When you are using today and today - 1 year. Till only give you revenue for those dates.

    Your simple sum of amount and the same period last year will give you that on a daily basis. Using the calendar you can view same at daily, month , qtr or for an year

     

    This period = CALCULATE(sum(Sales[Sales Amount]))
    
    last year same period = CALCULATE(sum(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date Filer]))

     

    There are other options for the month, qtr and year like datesmtd, totalmtd etc

     

    MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date Filer]))
    last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date Filer],-1,MONTH)))
    
    QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date Filer])))
    
    Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date Filer],-1,QUARTER)))
    
    YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date Filer])))
    
    Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date Filer],-1,Year)))

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

    My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601