Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Compare two dates

Hello.

1. I have two tables, as I can generate a measure or a column comparing two dates. One date from one table and the other from the other table?

2. In a KPI how can I replace "white" with 0, zero?

Thank you!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Syndicate_Admin , What you want to compare.  Usually we create a common date table, join fact/table date with those, and then compare for same or different duration

     

    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

     

    if([KPI] ="white","0", [KPI])

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Syndicate_Admin ,

     

    Could you pls provide some sample data or screenshots with expected output to make your issue more detailed?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!