Filter the date based on different conditions

[Anonymous]

Hi,

I have one table , in that i have few text columns district , dealer , and territery and others , including these i have remaing all are different date related columns , now i need to create a ne rolling up view , actually each district havong multiple dealers , and each dealer havong multiple territories in that way we have date , now based on district data was rolling up ,.... and if the status is completd then  completed date(column we have in table), if status is in progress -- expected date like that four conditions we need to give ,  addition with this , if include with this conditions and dates... if any blank date is there then we need to show blank or else max date we need to show 

please help me for this requirement

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

>> I will tell you with the following link, please open this link , this exact requirement i need , but here in place of item i have different text related data .https://community.powerbi.com/t5/Desktop/Report-the-latest-or-blank-date-value/m-p/328283#M146558

In this case, could you give an example of your item? What is the naming convention for your itme? Usually at least the item needs to contain text that can represent the sequence

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi tamerj1,

Thanks for respond,

I will tell you with the following link, please open this link , this exact requirement i need , but here in place of item i have different text related data .

https://community.powerbi.com/t5/Desktop/Report-the-latest-or-blank-date-value/m-p/328283#M146558

Thanks

[tamerj1]

Hi @Anonymous 
In the provided link the items are of integer type. It is wasy to identify the order of items but in your case you say it is text. Therefore, in case you have blank dates for some items then how would you identify the order of the items. Providing example from your own data along with the expected result is crucial as every case has it own unique behaviour and requirements. Thank you

[tamerj1]

Hi @Anonymous 

I know it is not easy to frame a question, it is even more difficult than answering it. 
I would advise you to present some sample data and describe you filter conditions one by one following one example ending up with the expected results.