Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to create different filters for different date columns?

Hi All,

 

In my dataset I have different date columns like: Application_Started, Processing_Started, Clear_To_Close , Docs_Out_date etc..

I am interested in pulling data for current month only, so I need to count number of application started this month using Application_Started column, number of application processesed using Processing_Started column and number of completed application using Docs_Out_date. 

For this I created a column, named Current_Month, and placed it in a Page level filter.

Current_Month = IF(YEAR(Encom[Docs_Out_Date].[Date]) = YEAR(TODAY()) && MONTH(Encom[Docs_Out_Date].[Date]) = MONTH(TODAY()),1,0)..

 

Now problem is, it is showing correct count (count for this month only) for Docs_Out_Date column which I am using to find number of application completed, but it is showing wrong count for Application_Started column which I am using to count number of application started.

 

I guess because I have used current_month column as a page filter using Docs_Out_Date only, but I cannot keep multiple filters for each column, as it is giving wrong counts.

 

Any suggestion please.

 

 

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Anonymous,

     

    Have you solved your problem?

     

    If you have solved, welcome to share your solution or accept the replies making sense as solution to your question so that more people will find workaround easily.

     

    Best Regards,

    Cherry

5 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi Anonymous,

     

    What about creating a Calendar table for your scenario? Then you could create a filter with the date in Calendar table.

     

    Here is a similar thread you could have a reference.

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Cherry, Thanks, I appreciate you reply.

      Yes I am doing Calendar visualization, so now the problem is I am not getting value for each day in the calendar visual but those days in the calendar are just highlighted though in the card I am getting correct value.

       

      My DAX query is:

      Loans_Closed = TOTALMTD([Loan Count], Encom[Docs_Out_Date])

      It is showing correct value in the card visual.

       

      But in calendar visual, nothing has been shown.

       

      Please let me know how can I show count in the calendar visual for each day whenever there is an event. (Please refer to the below picture)

       

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        8 years ago

        Hi Anonymous,

         

        It seems that you're using the custom visual Custom Calendar by Akvelon.

         

        By my test with this custom visual, this visual may not show the count, it only show the color for different metrics.

         

        For your requirement, you could try with another custom visual  Beyondsoft Calendar Custom Visual which has the Measure Filed.

         

        Best  Regards,

        Cherry