if statements and date

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » If statements and date differences for values on separate tables

If statements and date differences for values on separate tables

resolvedResolved · Low Priority · Version 2016

If statements and date differences for values on separate tables

Hi!

I have a table visual which shows The client, the total amount owed, the last payment date and the next installment due date.

The last payment date and the next installment due date are on different tables.

I am trying to write a measure that says if the next installment due date is is greater than the last payment date, to mark "due" in another column. I can get the value of the difference using

Pledge Chase = datediff(SELECTEDVALUE(Pledges[Instalment Date Due]),SELECTEDVALUE('Original Pledges'[Latest Payment Made]),DAY)

But if i turn this into an if statement, I get multiple many duplicate rows in the table. Not sure why!

RE: If statements and date differences for values on separate ta

Hi Lou,

Thank you for the forum question.

I will need more details to help you.

Do you work with a date table?

When you write you get duplicates, do you mean that the clients appear many times in the table visual and not only show the latest payment date?

If this is the problem you will need to use the Max function to only look at the latest date.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Create Interactive Dashboards

Build interactive dashboards by leveraging features like slicers, drill-through, and bookmarks. Slicers allow users to filter data dynamically, while drill-through enables detailed exploration of specific data points. Bookmarks help you save the current view, making it easy to switch between different states of your report.

View all Power BI hints and tips


Server loaded in 0.07 secs.