Forum Discussion

gazz9ar's avatar
gazz9ar
Frequent Visitor
6 years ago
Solved

Between 2 dates in FILTER function

Hi there,    I need to filter a table based on a selected MONTH and YEAR,  the user can select multiple months also.  This is my measure:   Total Checks (SINDESC) Filtered = VAR selectedyear ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi gazz9ar ,

Try this one please.

Total Checks (SINDESC) Filtered =
VAR selectedyear =
    SELECTEDVALUE ( Dates[Año] )
VAR selectedmonth =
    ALLSELECTED ( Dates[MonthNum] )
RETURN
    CALCULATE (
        [Total Checks (SINDESC)];
        FILTER (
            Cobros;
            Cobros[Fecha Contabilizacion] >= DATE ( selectedyear; selectedmonth; "01" )
                && Cobros[Fecha Contabilizacion] <= DATE ( selectedyear; selectedmonth; "31" )
        );
        USERELATIONSHIP ( Dates[Date]; Cobros[Fecha Vencimiento Cheque] )
    )

If it doesn't meet your requirement,  Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

gazz9ar's avatar
gazz9ar
Frequent Visitor
6 years ago

v-frfei-msft  sorry for spamming you, i just want to be clear

 

Here is a image of what i want to do:

The table will change as you change the period, and the bar chart should change based on the "Fecha Vencimiento" column too.

 

I dont need the table, is just a visual help