Forum Discussion

oren's avatar
oren
Helper III
2 years ago

Add filter for ranges

Hi   I have a member database with three columns: one for account ID, one for 'from date' (the start date of the membership), and one for 'end date' (the end date of the membership). Is there an o...
Need Help
Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi oren 
If i understood you correctly please refer to linked tutorial :

https://radacad.com/subscription-pattern-in-power-bi-dax-measure-for-active-subscribers-or-open-tickets-for-all-dates

if not 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

oren's avatar
oren
Helper III
2 years ago

hi again,

 

i used this to count subs- and it worked good- thank you!!

but now i ahve anothre step whenm i need to add another measure for the average income for each day ( named as "[LowestPricePerCarat_Calc]" so i semple changed one row to :

var _countRows=AVERAGE('Query1'[LowestPricePerCarat_Calc])
insted of :
var _countRows=countrows(_subscribers)
but i am getting a wrong answar.. 
what did i do wrong ?
 
thank you!