Forum Discussion

Pricey79's avatar
Pricey79
Helper V
5 years ago
Solved

Help with Target Dates Please

Hello, I was hoping someone could help me please.   I have 2 fields in the same query called Target Date and Actual Date. Then I have another field in the same query called Product. I need to be a...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Pricey79 , There two approach I can think.  You have date table and only actual date is joined to it

new measure =
var _max = maxx(allselected('Date'), Date[Date])
var _min = minx(allselected('Date'), Date[Date])
return
divide(count(Table[product]),calculate(count(Table[product]), filter(Table, Table[Target Date] >=_min && Table[Target  Date]<=_max)))

 

 

Second, Target date is also joined to date table as inactive join

new measure =

divide(count(Table[product]),calculate(count(Table[product]), userelationship(Table[Target Date], 'Date'[Date])))

 

Or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Pricey79's avatar
Pricey79
Helper V
5 years ago

amitchandak  Thank you for your reply.

Apologies, im a novice at this. What Date goes here please? 

var _max = maxx(allselected('Date'), Date[Date])
var _min = minx(allselected('Date'), Date[Date])
return