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

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.