Forum Discussion

andyhere's avatar
andyhere
Frequent Visitor
7 years ago

remove date from context then do cumulative

Hi,   I want to write a measure that removes the current Date context, but retains the rest of the context in order to get current capacity. My original data is 1 row per item, with dates for whe...
Need Help
andyhere's avatar
andyhere
Frequent Visitor
7 years ago

Hi Maggie,

 

Thanks for your detailed response!

 

Why does the date/calendar table need to have no relationship to the data table? I would like to retain a relationship there for other graphs.

 

I tried making the first measure you suggested, but using ALLSELECTED I am unable to access the dates columns inside the filter, i guess because there is a relationship set up?

 

thanks,

 

Andy

 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi andyhere

Please keep the calendar date table( i referred in my previous post) unconnected to your data table so that your problem here can be sloved.

 

To use date from a date table for other visuals, you could create another calendar date table and create relationships among this new calendar date table with your data tables.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.