Forum Discussion

spamspam's avatar
spamspam
Regular Visitor
7 years ago
Solved

Filtering Multiple Date Columns in one Report

Hi All,   I have been using Powerbi for a few months, report writing ect and i am stuck on this.   I have 3 date columns, for different types of Insurances, i want to be able to see any that are ...
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi spamspam

     

    It seems you may try to use DATEDIFF Function to create the measures for each column as requested. For example:

    UpdateWorkersComp =
IF (
    DATEDIFF ( NOW (), MAX ( 'Sample'[Workers comp] ), DAY ) <= 30,
    MAX ( 'Sample'[Workers comp] )
)

    Regards,
    Cherie

sizi's avatar
sizi
Helper II
2 years ago

Hi Sreenath,

 

I have 9 date columns and i want a date filter which when filtered should show any records from any of the 9 date columns falling in the date range. Can you help plz? 

 

For ex: For last 1 month; i want to see all the records that fall in this category from all 9 date columns. Basically if every date column has a date that falls in last 1 month, then those records should show. I am not able to find solution to this. Kindly help. Thanks,

 

Below is the data :

Task#UserTask NamePlanned StartPlanned EndActual StartActual EndIT ApprovalInitial ApprovalTechnical ApprovalFinal ApprovalStatus
1JohnTask 110/2/2023 0:0010/8/2023 0:0010/2/2023 0:0010/8/2023 0:0012/26/2023 0:0011/4/2023 0:0012/13/2023 0:00 In Progress
2JohnnyTask29/12/2023 0:009/27/2023 0:009/12/2023 0:0012/2/2023 0:00    On-hold
3ClaireTask3        On-hold
4VennaTask412/3/2023 0:00 12/3/2023 0:0012/13/2023 0:00    In Progress
5SierraTask59/30/2023 0:0010/4/2023 0:00      Canceled
6AdamTask6        Completed
7JohnTask79/24/2023 0:009/25/2023 0:009/25/2023 0:009/25/2023 0:00    Completed
8JohnnyTask811/6/2023 0:0011/8/2023 0:0011/6/2023 0:0011/11/2023 0:00 11/12/2023 0:0011/19/2023 0:00 Completed
9ClaireTask99/9/2023 0:009/11/2023 0:009/9/2023 0:009/11/2023 0:00 10/1/2023 0:0010/1/2023 0:00 Completed
10VennaTask1012/23/2023 0:001/3/2024 0:0012/23/2023 0:001/3/2024 0:00 1/14/2024 0:001/7/2024 0:001/17/2024 0:00Completed
  • sizi's avatar
    sizi
    Helper II
    2 years ago

    I cannot unpivot the date columns in power query. its giving error. My datasource is sharepoint. Is there any other way i can define date filter which can filter dates based on any date column?

    Thanks,

    • gmsamborn's avatar
      gmsamborn
      Super User
      2 years ago

      Hi sizi 

       

      To unpivot the date columns, I selected [Task#], [User], [Task Name] and [Status] and then right-click and select "Unpivot Other Columns".

       

      If this doesn't work, please let me know what the error was.