Forum Discussion

akramayman's avatar
akramayman
Frequent Visitor
3 years ago
Solved

startofmonth function

I have an issue my dax using the startofmonth function and in total it gives me the value of Jan  where i can´t make a relation between date table and the 'Corporate Forecast' table.  CALCULATE( ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi akramayman 

    Try to add allselected() .

    e.g

    CALCULATE(
        sum('Corporate Forecast'[Month Value]),
        FILTER(
                ALLSELECTED('Corporate Forecast'),
                STARTOFMONTH('Table'[Date])
                 = 'Corporate Forecast'[Start Date (help)]
                    && 'Corporate Forecast'[Report] = "CLOSED"
            )
        )

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi akramayman 

Try to add allselected() .

e.g

CALCULATE(
        sum('Corporate Forecast'[Month Value]),
        FILTER(
                ALLSELECTED('Corporate Forecast'),
                STARTOFMONTH('Table'[Date])
                 = 'Corporate Forecast'[Start Date (help)]
                    && 'Corporate Forecast'[Report] = "CLOSED"
            )
        )

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.