Forum Discussion
Solved
Calculate column according to a different date table
Hi! I would like to compare a date field from a table with a general date table that I am using as a slicer to filter data. Data table looks like this: Report Due Date Overdue...
Try pulling through the largest value in your date table as a variable and then compare your due date column to that?
Hi 21818 ,
As jthomson mentioned, the solution is to compare the maximum value of your slicer to the due date in your table.
Here is the formula you can use:
Overdue = VAR dueDate = SELECTEDVALUE('Table'[Due date]) RETURN IF(MAX('Dates'[Date])<dueDate,"N","Overdue")And a screenshot showing the end result
Regards,
LC
Interested in Power BI finance templates? Check out my blog at www.finance-bi.com
Hi lc_finance and jthomson ,
I managed to solve this using your suggestions.
Many thanks for your help.
lc_finance
Solution Sage
Solution Sageglad to hear you found a solution.
Let us know if you need more help,
LC