Use a measure to dinamically change dates on other measures

[krist_pbi]

Hey, I believe this is pretty quick, I want to create a measure that can be dinamically filter by another measure that only contains a date.

For example, create a calculate similar to this  = CALCULATE ( [total sales], calendar[date] = [date measure])  and being able to filter the sales by referencing the measure that contains the date without putting the date manually in the calculate, 

is this possible? I tried but gave me an error

[v-karpurapud]

Hi @krist_pbi 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @krist_pbi 

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @Ahmedx  and @Ashish_Mathur , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the shared details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team.

[Ashish_Mathur]

Hi,

Does this work?

Measure = CALCULATE([total sales],FILTER{'calendar','Calendar'[Date]=[date measure]))

[Ahmedx · Accepted solution]

To avoid getting an error, you need to use the FILTER function.

Measure 5 = CALCULATE([Fact $],  KEEPFILTERS( FILTER(ALL('Calendar'),'Calendar'[Date] =[measure date])))

[Ahmedx]

pls try 

Measure 5 = CALCULATE([Fact $],  KEEPFILTERS( TREATAS({[measure date]},'Calendar'[Date])))