Forum Discussion
DAX Measure Comparing two Date from two columns
Hello everybody,
I hope someone can help me.
I've got two columns with Dates.
1. Column: Planned Date
2. Column: Release Date
I want to count every row where the Release Date was after the Planned Date.
Can someone help me?
I was going for something like:
Count_Func = Calculate ( SUM(tsble), Filter (Planned Date< Release Date))
But it didn't work.
Thank you in advance.
Hi Anonymous ,
Try doing something like this:
1) On your table, create a column "date_flag"
date_flag = if (Planned Date< Release Date, 1 , 0)2) Then create your measure
Count_Func = COUNTROWS( Filter (<table_name>, date_flag = 1))
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
2 Replies
Hi Anonymous ,
Try doing something like this:
1) On your table, create a column "date_flag"
date_flag = if (Planned Date< Release Date, 1 , 0)2) Then create your measure
Count_Func = COUNTROWS( Filter (<table_name>, date_flag = 1))
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂