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
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 😞