Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

measure

Hello, Can you help with the following please? There are three tables in model... PTable ---------- PKey PCode myDate --------- DateKey DateValue calendarDateYear CalendarQuarter StartQu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

You can create the measures with below formulas:

Measure_1 =
VAR curdate =
    MAX ( 'Fact'[DateKey] )
VAR predate =
    CALCULATE ( MAX ( 'Fact'[DateKey] ), 'Fact'[DateKey] < curdate )
RETURN
    CALCULATE ( MAX ( 'Fact'[Price] ), 'Fact'[DateKey] = predate )
Measure_2 =
CALCULATE (
    MAX ( 'Fact'[Price] ),
    FILTER (
        ALL ( 'Fact'[DateKey] ),
        RIGHT ( 'Fact'[DateKey], LEN ( 'Fact'[DateKey] ) - 4 )
            = MAX ( 'QuarterDateStart'[QuarterStartDateKey] )
    )
)

And I created a sample pbix file, you can get it from this link.

Best Regards

Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I get error in Measure_2

The syntax for ')' is incorrect. ...

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Measure_2 seems to give the same value for all the rows which is not correct

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      Could you please provide some screen shots about your visuals and applied measures in report? Thank you.

      Best Regards

      Rena