CODE EXAMPLE FOR SQL

power bi dax is in the last 3 months

3mo Sales = CALCULATE(DISTINCTCOUNTNOBLANK('Sales Data'[SaleNo]), DATESINPERIOD('Calendar'[Date],TODAY(),-3,MONTH))

// Note - The date column being filtered must have no gaps in date