Forum Discussion

rtaylor's avatar
rtaylor
Helper III
6 years ago
Solved

Measure: Projection based on max date while establishing/maint a date relationship in another column

Hello and Thanks for your Help!,   Sample Report https://drive.google.com/a/mail.sdsu.edu/file/d/1TzC1ljUvrejDgtxjkiP6K1EWFnodrv45/view?usp=sharing   I'm trying to create a measure that calculati...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi rtaylor ,

     

    Please update the relationship between tables as below.

     

    After that, set the interactions of your visuals to filter. Then we can get the excepted result.

     

    Pbix as attached.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi rtaylor ,

 

We can create relationship between date table and the fact table like that.

 

Based on that, USERELATIONSHIP can help you in your scenario.

Measure = CALCULATE(SUM('Table'[ Amount]),USERELATIONSHIP('date'[Date],'Table'[Date Month]))