Need date column or Measure based on condition.

[NavaneethaRaju]

Hello Everyone,

based on my requirement i need the date column based on this condition,

like Order Date> Missing Since date , please advice the measure to display the column like this. after that missing date, how many order has been placed, that count i have to find.

Please advice. I enclosed the images like my expected result.

Needed Result:

Please advice some measure for showing the count of orders after the missing since date.

[Greg_Deckler]

@NavaneethaRaju If I understand this correctly, perhaps somethinge like:

Order Count Column =
  VAR __MissingSince = [Consign Fact.Missing Since]
  VAR __Table = FILTER('Table',[Tag Fact.Order Date] >= __MissingSince)
RETURN
  COUNTROWS(__Table)

Order Count Measure =
  VAR __MissingSince = MAX([Consign Fact.Missing Since])
  VAR __Table = FILTER(ALLSELECTED('Table'_,[Tag Fact.Order Date] >= __MissingSince)
RETURN
  COUNTROWS(__Table)

[NavaneethaRaju]

Hi @Greg_Deckler , 

Thanks for your earliest response.

the measure is creating duplicates and it showing total order count for that tag, not working with condition.

After using the measure its creating duplicates and order count was showing 5 in table but it should be 2:

I enclosed the sampledate.pbix file, please advice.

[Greg_Deckler]

@NavaneethaRaju Do they need to be the same Tag ID? I feel like there is some missing information regarding the specific business rules for the calculation.

[NavaneethaRaju]

Hi @Greg_Deckler ,

No, i have to show only one record for each Tag ID like this. that would enough for me.

The relationship would be many to many between Tag and Consign table.
Please advice, if i bring the Missing Since date in Tag usage fact table that would solve the issue.???
And also i enclosed the Pbix file, that might help you more.