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

Hi Cherie,

 

Thanks for the reply,  Here is my Insurances due in 30 days screen shot

 

To the left if these is just company name. These dates are in the same table

 

Data is only pulling through if any of the Workers Comp/Public or Motor match the condition of 30 days

 

I am expecting alot more data, with some being blank because the expiry is in date.

 

I just have page filters setup on each date column "Is in the next 30 days"

 

Hope this helps to show what iam missing

 

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
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