98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Low Priority · Version 2016
Lou has attended:
Power BI Modelling, Visualisation and Publishing course
Excel VBA Introduction course
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
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Create Interactive DashboardsBuild 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. |