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