Forum Discussion
How to use a specific value from a month
Hello!
Im having problems to use a certain value, my measure is to compare my actual month to a fixed month but I don't know how to filter this value,
I've already used filter(all(dcalendar(month),Dcalendar(month) ="august")) ... it didn't work!
I've already used filter(datesbetween(dcalendar,"01/08/2022","31/08/2022"))) ... it didn't work, and when i used these filter all my formulas got filtered!!!
could someone help me with this?! I'll be very grateful!
1 Reply
- grandtotal
Resolver III
You can try this measure for the fixed month value calculation
CALCULATE (
[Sales Amount], -- Computes sales amount
'dcalendar'[month] = "august", -- Where month is "august"
ALL ( 'dcalendar') -- Removes any other filters from dcalendar
)I hope this will guide you to the right direction.
