Forum Discussion
summarize and selectcolumns problems
Hi. I'm trying to SELECTCOLUMNS() to return a table with a single column [customer1] and then use SUMMARIZE() to count how many rows are present for each customer. This sounds fairly simple but I nee...
Anonymous , check if this between logic can help
Hi Anonymous ,
Please try:
Measure = CALCULATE(COUNT('Table'[customer]),FILTER('Table',[startdate]>=MIN('date'[Date]) && [stopdate]<=MAX('date'[Date])))Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.