Good afternoon everyone,I am new to dax and need to get the sum of sales as follows:Sales from day 1 to day 30Sales from the 31st to the 60thIt's possible?Thank you

Can you attach a screenshot of the data you are working with

Hi ricardo_cvo,It's hard to provide specific solution without sample table. After research, the following thread and articles are useful. In my oppion, you can do your cases after learn them carefully.filtering-and-comparing-different-time-periods-with-power-biDynamically comparing current totals to last year totalsTotal Sales X Custom Period (day 26 current month to day 25 next month)POWER BI: Modeling Thanks,Angelia

Thank you all for the answers:The data unfortunately can not share, but I am using the formulas below for 30 days and for 60 days: 30 Days = CALCULATE(SUM(FatSales[);FILTER(ALL(FatVenda[Date of Sale]);FatVenda[Date of Sale]>TODAY()- 30))60 Days = CALCULATE(SUM(FatSales[Date of Sale]);FILTER(ALL(FatVenda[Date of Sale]);FatVenda[Date of Sale]>TODAY()- 61)) Tanks

Hi ricardo_cvo,The syntax is right, you get the expected result? If it is, please mark your reply as answer, so more people will benefit from here.Thanks,Angelia

Hello,Thank you for replying, yes the synthesis is correct, but it brings the data of the last 30 days and the last 31 days, I need to get it as follows:Adding Sales from Day 01 to Day 30Adding Sales from Day 31 to Day 60Can you understand?

Dax Sales by Period | Microsoft Fabric Community

21 Replies

gregcd
Frequent Visitor
8 years ago
Can you attach a screenshot of the data you are working with
- v-huizhn-msft
  Microsoft Employee
  8 years ago
  Hi ricardo_cvo,
  
  It's hard to provide specific solution without sample table. After research, the following thread and articles are useful. In my oppion, you can do your cases after learn them carefully.
  
  filtering-and-comparing-different-time-periods-with-power-bi
  Dynamically comparing current totals to last year totals
  Total Sales X Custom Period (day 26 current month to day 25 next month)
  POWER BI: Modeling
  
  Thanks,
  Angelia
  - ricardo_cvo
    Helper I
    8 years ago
    Thank you all for the answers:
    The data unfortunately can not share, but I am using the formulas below for 30 days and for 60 days:
    
    30 Days = CALCULATE(SUM(FatSales[);FILTER(ALL(FatVenda[Date of Sale]);FatVenda[Date of Sale]>TODAY()- 30))
    60 Days = CALCULATE(SUM(FatSales[Date of Sale]);FILTER(ALL(FatVenda[Date of Sale]);FatVenda[Date of Sale]>TODAY()- 61))
    
    Tanks
Washivale
Resolver V
8 years ago
HI Ricardo,

Check the following if it works:

Sales 1 to 30 Days = CALCULATE([Sum Sales], DATESBETWEEN(dCalendar[Date],MAX(fSales[Date of Sale])-60,MAX(fSales[Date of Sale])-30))

Sales 31 to 60 Days = CALCULATE([Sum Sales], DATESBETWEEN(dCalendar[Date],MAX(fSales[Date of Sale])-30,MAX(fSales[Date of Sale])))

Thanks,
Sandeep
- ricardo_cvo
  Helper I
  8 years ago
  Thanks for the feedback,
  
  I tested the Sales 31 to 60 Days formula that in the example is from 06/13 to 07/07 and is giving 123537,10 how much the value should be 118692.82.
  
  Regards
  - Washivale
    Resolver V
    8 years ago
    Hi Ricardo,
    
    Please give it a try with below measures.
    
    Sales 31 to 60 Days =
    var ld = CALCULATE ( MAX ( dCalendar[Date] ), ALLSELECTED ( dCalendar[Date] ))
    var sd = ld-30
    return
    CALCULATE([Sum Sales], DATESBETWEEN(dCalendar[Date],sd,ld))
    
    Sales 1 to 30 Days =
    var ld = CALCULATE ( MAX ( dCalendar[Date] ), ALLSELECTED ( dCalendar[Date] ))
    var sd = ld-60
    var lp = sd + 30
    return
    CALCULATE([Sum Sales], DATESBETWEEN(dCalendar[Date],sd,lp))
    
    let me know if it works

Forum Discussion

Dax Sales by Period

21 Replies

Related content

Sales LY till same period

Sales Last month and Last month same period

Showing 13 periods

DAX Last Year Sales

Sales total For Specific period