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


Thanks v-frfei-msft , sadly it threw an error.  Anyway i tried a measure with the same structure and the problem still in the slicer and the visual.

 

Please check the file, the page is called HERE. (it is in Spanish, but i think you will understand, i left you notes).

 


Pbix File: https://1drv.ms/u/s!AttE7DRi4S6HilwL7h2gEeXlZBF-?e=XIiC7N

 

Thank you.

  • gazz9ar's avatar
    gazz9ar
    Frequent Visitor
    6 years ago

    Here is my measure, that is working.

     It is the SUM of every Check, filtered by month and year. 

     

    Here you can see in a table the  Total for every date in "Fecha Vencimiento Cheque", how should i group by that date in the given visual?

     

    NOTE: if i add to the CALCULATE a filter with USERELATIONSHIP, it shows a wrong Total ($1million ), you can check the records.

     

    BUT the visual should group by that Date.  Im starting to think it is not possible 😞