Forum Discussion
Syndicate_Admin
Administrator
2 years agoVerification between dates
Let's imagine that I have the following table: Code cod_int date CT1 seg_client 1/4/2024 CT1 seg_client 3/6/2024 CT1 seg_client 18/6/2024 CT2 seg_client 3/3/2024 I...
- Anonymous2 years ago
Thanks for the reply from amitchandak , please allow me to provide another insight:
Hi Syndicate_Admin ,Here are the steps you can follow:
1. Create measure.
Measure = var _column= SELECTCOLUMNS( FILTER(ALL('MovInteracciones_sql'), 'MovInteracciones_sql'[date]>=DATE(2024,6,1) && 'MovInteracciones_sql'[date]<=DATE(2024,6,15)&&'MovInteracciones_sql'[cod_int]="seg_client"),"test",[Code]) return CALCULATE( COUNTROWS( 'MovInteracciones_sql'), FILTER('MovInteracciones_sql', NOT('MovInteracciones_sql'[Code]) in _column) )2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous
2 years agoNot applicable
Thanks for the reply from amitchandak , please allow me to provide another insight:
Hi Syndicate_Admin ,
Here are the steps you can follow:
1. Create measure.
Measure =
var _column=
SELECTCOLUMNS(
FILTER(ALL('MovInteracciones_sql'),
'MovInteracciones_sql'[date]>=DATE(2024,6,1) && 'MovInteracciones_sql'[date]<=DATE(2024,6,15)&&'MovInteracciones_sql'[cod_int]="seg_client"),"test",[Code])
return
CALCULATE(
COUNTROWS(
'MovInteracciones_sql'),
FILTER('MovInteracciones_sql',
NOT('MovInteracciones_sql'[Code]) in _column)
)
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Syndicate_Admin2 years ago
Administrator
It seems to be going great. Thank you!