I have two tables. In the one I split a particular date into a DAY , MONTH and YEAR. I need to use the MONTH and YEAR from this table and the DAY from another table in this way:
Solved! Go to Solution.
Well, would need to better understand the data to say anything definitive. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But I suppose you might need to check to make sure that you are not getting a text value or something odd for your Payment Day Related.
VAR pay_year ='Payment Summary'[Payment Year]
VAR pay_month = 'Payment Summary'[Payment MONTH use]
VAR pay_day = 'Payment Summary'[Payment DAY related]
VAR pay_year_OK = pay_year >0
VAR pay_month_OK = pay_month > 0 && pay_month <=12
VAR pay_day_OK = pay_day > 0 && pay_day <=31
Result = IF(pay_year_OK && pay_month_OK && pay_day_OK,date(pay_year,pay_month,pay_day), "Error in year, month or day")
You could put more complex logic on the limits for pay_day depending on the value of pay_month
Hi .. thank you so much for your quick response .. I am a fairly new user adn although I'm sure what you sent is fairly easy I am not entirely sure how to do replicate in my model. Would you be able to spend a minute via Teams so I can share my screen and you can talk me through it?
thanks so much... I can't use Zoom on my work laptop so I'm going to quickly transfer the file to my peronsal laptop.
My mail is: email@example.com
I should be ready in 15 minutes.
thanks so much
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications