Forum Discussion

Nazar11's avatar
Nazar11
Regular Visitor
1 year ago

Measure development

Hi all,    I am seeking support with creating a measure:  ACCEPTANCE CRITERIA:  calcualte the values in the project_details table from the total Value column when the realization start month is 2...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Nazar11 ,

 

Thanks to BeaBF  for their interest in this issue. I have some other thoughts to add:

(1) We can create a table.

project_details_2025 = FILTER(
        project_details,
        project_details[Realization Start Month] >= DATE(2025, 1, 1) &&
        project_details[Realization Start Month] <= DATE(2025, 12, 31) &&
        project_details[Phase] = "Execution"
    )

(2) We can create a measure.

Measure =
VAR _value =
    SUM ( 'project_details_2025'[Total Value] )
VAR _rate =
    CALCULATE (
        SUM ( 'exchange_rate'[Exchange Rate] ),
        FILTER (
            ALL ( 'exchange_rate' ),
            [Currency To] = SELECTEDVALUE ( 'exchange_rate'[Currency To] )
                && [Rate Period] = SELECTEDVALUE ( ASP_versions[Year] )
        )
    )
RETURN
    _value * _rate

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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