Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter the date based on different conditions

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

4 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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. 

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      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

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.