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.

     

rtaylor's avatar
rtaylor
Helper III
6 years ago

>

Sorry, I don't understand.

You've selected 3/15/2019 and all rows with that date are selected. So what is the requirement?

 

I want to be able relate the date to a date table, and plot the data accross time if need be.  Right now the relationship between the date column and the date table are not functioning

 

>

Also, you want to use a CROSSFILTER so I think you should show us the model

I only want to use crossfilter because it looks like that is only option that will work. If you know of better method, please let me know.
 
Also I will have to create a sample model with fake data. I will reply once that is complete.
  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    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.