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

spamspam's avatar
spamspam
Regular Visitor
7 years ago

Hello,

          New to PowerBi, I have 3 date fields, they are different types of insurances,with a company name attached to the date field and i need to see the expiery in the next 30 days.

They are currently in the table visual, and i have setup page level filters, Relatative Date Filtering  "IS in the next 30 Days"

 

My problem it is only showing data if all 3 dates are expiering in the next 30 days, how can i make it show data from each indivual date column, and if say 2 date column 2 and 3 are not out it is just blank.

 

Cheers In Advance