Yesterday = CALCULATE(SUM('Table'[Tons]), FILTER('Table','Table'[Date]=TODAY()-1)) But Now I want to add a logic to it that , "if today is Monday then add the shipment of Friday +Saturday + Sunday as previuos day shipment; else previous day shipment" Date Tons Y...
Yesterday = CALCULATE(SUM('Table'[Tons]), FILTER('Table','Table'[Date]=TODAY()-1)) But Now I want to add a logic to it that , "if today is Monday then add the shipment of Friday +Saturday + Sunday as previuos day shipment; else previous day shipment" Date Tons ...