Forum Discussion

fmigg's avatar
fmigg
New Member
7 years ago

Problem on Data Filter on Table.

Hi, I'm doing a self-purpose dashboard in which I have to filter expenses from 9 of actual month to 8 of the next month. This is my formula:    CC- Total a Pagar = IF(DAY(TODAY()) > 8, CALCUL...
Need Help
Show and Tell
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, fmigg

After my test, It is because that you drag field date into visual and it could be aggregated,

so it will display multi-row data.

You may try this way

add a measure

type = 
IF (
    DAY ( TODAY () ) > 8,
    "from 9 of actual month to 8 of the next month",
    "from 8 of last month to 8 of the actual  month"
)

then drag into visual instead of the date field.

 

Best Regards,
Lin