Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help With Date

Hi all,   I'm trying to compare a date measure with a date in my data table.  The date measure I have is:   IF(CALCULATE(SUM(YieldDataTable[RunQuantity]), FILTER(YieldDataTable,YieldDataTable[Run...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

Thanks for your reply.  However, I don't believe that was the problem as the measure still does not output anything.  

The output to my last productiond date measure is 10/9/2019, hence the output to this measure should be 10/8/2019.  But it's currently returning blank.

 

I believe it has something to do with how powerbi is comparing dates and how it cannot compare date from a measure to a date in the data table.  However, I don't exactly know why or how to fix it.

 

Do you have any advice?

 

Thanks.

MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

Can you share a sample of your file and expected result? If information is sensitive can you do it trough private message?

 

Regards,

MFelix