CALCULATE NO. OF ORDERS between Last Order Rating date and today's date

[Andrew_na_lang]

Hi Power BI Fam,

I need help! I am stuck with something. 

I need to get the number of orders booked by the customer from the Last order Rating date to TODAY. 

Any help is much appreciated!!!!

 

[Andrew_na_lang]

@amitchandak it didn't work.😶

[V-lianl-msft]

Hi @Andrew_na_lang ,

The screenshot you provided cannot provide effective information. Unfortunately, I don't know which fields to calculate the number of orders. You can paste some sample data and the results you expecthttps://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Andrew_na_lang , Try a measure like

measure =
var _max = calculate(max(Table[Last order Rating date]), allexcept(Table, Table[customer])) //or // maxx(allselected(Table) ,Table[Last order Rating date])
return
calculate(count(Table[Order]), filter(Table, Table[Last Order Date] >= _max && Table[Last Order Date] <=Today()))