topic Re: Filter the date based on different conditions in DAX Commands and Tips

Filter the date based on different conditions

Anonymous — Thu, 18 Aug 2022 18:42:57 GMT

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

Re: Filter the date based on different conditions

tamerj1 — Thu, 18 Aug 2022 19:34:47 GMT

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.

Re: Filter the date based on different conditions

Anonymous — Fri, 19 Aug 2022 02:56:37 GMT

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

Re: Filter the date based on different conditions

tamerj1 — Fri, 19 Aug 2022 05:53:16 GMT

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

Re: Filter the date based on different conditions

v-xiaotang — Tue, 23 Aug 2022 02:20:58 GMT

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.