Answers for "Year To Date Sales formula"

0

Year To Date Sales formula

YTD Sales: = 
    CALCULATE (
          [Total Sales],
          FILTER (
               ALL ( 'DateTable' ),
                    'DateTable'[DateYear] = MAX ( 'DateTable'[DateYear] ) &&
                    'DateTable'[Date] <= MAX ( 'DateTable'[Date] ) 
       )
    )
Posted by: Guest on August-24-2021
0

Year To Date Sales formula

YTD Sales = TOTALYTD( [Total Sales], 'DateTable'[DateColumn] )
Posted by: Guest on August-24-2021

Browse Popular Code Answers by Language