Forum Discussion

Poplin's avatar
Poplin
New Member
2 years ago

Isssue with Calculate with DAX

I'm trying to aggregate planned sales after September 2024 on a monthly basis using the following DAX expression: ■DAX SalesBP = VAR BPMonth = [BPMonth] RETURN CALCULATE('Measure'[Planned Sales...
Need Help
tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

Poplin 

 

 I guess, because of your computer region settings, Power BI is assuming "2024/8/1" as Jan 8th 2024 instead of August 1st 2024. Try changing the value in your BPMonth measure to "2024/1/8" and see the result.

 

Date() function worked for your because, the sequence of parameters that date function accepts are Year, Month and Date and you passed them correctly.

 



Need Power BI consultation, hire me on UpWork .


If the post helps please give a thumbs up



If it solves your issue, please accept it as the solution to help the other members find it more quickly.




Tharun



 

  • Poplin's avatar
    Poplin
    New Member
    2 years ago

    Thank you for your reply.

    I hadn't considered that the issue might be related to my computer's region settings.

     

    Because my explanation may have been unclear, let me clarify:
    The BPMonth measure is calculated as follows:

     

    ■ BPMonth measure
    BPMonth = EDATE(DATEVALUE("[ActualDate]" & "/1" ))
    ※ ActualDate = "2024/5"

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Poplin ,

       

      It's the context that causes the problem, how [BPMonth] is defined as a date, and the results it returns when put into different visual objects may be different. If it's a dynamically customized value, I'd recommend that you create an unrelated schedule and get that date via selectvalue().

       

      Hope it helps!

       

      Best regards,
      Community Support Team_ Scott Chang

       

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