Compare two dates

[Syndicate_Admin]

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!

[v-kelly-msft]

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!

[amitchandak]

@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])