Forum Discussion

wolfsvein's avatar
wolfsvein
Regular Visitor
8 years ago

Help Need DAX row count between dates

=CALCULATE(COUNTROWS(Fact_SalesSummaries), DATESINPERIOD(Fact_SalesSummaries[BidWonDate], LASTDATE(Fact_SalesSummaries[BidWonDate]), -3, MONTH), Fact_SalesSummaries[BidWon...
PietroFarias's avatar
PietroFarias
Resolver II
8 years ago

I'm not good with SQL, so i want understand what you need.
Do you need retrieve the number of rows where:
1. Start 03 month back and finish the last date previous the current date.
2. BidWonDate <> Blank.

Yeah? Or did I change everything? haha

wolfsvein's avatar
wolfsvein
Regular Visitor
8 years ago

SO what is needed is a rolling 3 month count of records between prior 3 months and current date, and the records are not blank().

 

I even tried does this in a measure.

 

calculate(countrows(date), datesbetwween(date[field], eomonth(lastdate(date[field]),-4)+1, eomonth(lastdate[date[field],0)))