Forum Discussion

GKs's avatar
GKs
Frequent Visitor
6 years ago
Solved

Running Total Specific Year

I would like to be able to compare a specific year against another by means of its days, that is to say that in a month X from day 1 to 30 to be able to see the evolution of sales day by day in an ac...
Data Protection
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this measure

    Cump Ac 2018 = IF(ISBLANK([2019 Sell Out]),BLANK(),CALCULATE([2018 Sell Out], FILTER(ALLSELECTED(Table[Sell Out]),Table[Date] <= MAX(Table[Date] ))))

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Try this measure

Cump Ac 2018 = IF(ISBLANK([2019 Sell Out]),BLANK(),CALCULATE([2018 Sell Out], FILTER(ALLSELECTED(Table[Sell Out]),Table[Date] <= MAX(Table[Date] ))))

  • GKs's avatar
    GKs
    Frequent Visitor
    6 years ago

    thank you very much for your help.
    I think the problem may be in the blank is only taking the range within 2019.

    Try this way however the same happens if I include the If with the ISBLANK and BLANK.

     

    Cump Ac % 2018 =
    VAR AC2018= CALCULATE(SUM(Table Sell out[Sell Out]), FILTER(ALLSELECTED(Table date),Table date[date] <= MAX(Table date[date])))
    RETURN
    CALCULATE( AC 2018,
    SAMEPERIODLASTYEAR(Table date[date]),ALL(Table date))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI GKs ,

      These blank parts mean they not have corresponded table records, I think you need a calendar table with whole dates. Then you can use calendar date as axis and looping table records based on the calendar date.

      Understanding DAX Auto-Exist 

      Cumulative Total 

      Regards,

      Xiaoxni Sheng

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      Share the link from where i can download your PBI file.