Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everybody,
I have two columns in my table:
ReportingYear
ReportingPeriod
Is is possible to add a custom column to combine the two to show an actual date? The day can be the first of the month. So for example when the year is 2022 and the reporting period is 5 I would like it to show:
1-5-2022
1 = day
5 = month
2022 = year
I tried a number of things, but I keep getting errors.
Solved! Go to Solution.
Hi @lekkerbek ,
Plese try the below:
Thank you!
In case it answered your question, please accept it as a solution.
Appreciate Your Kudos.
Hi @lekkerbek ,
Plese try the below:
Thank you!
In case it answered your question, please accept it as a solution.
Appreciate Your Kudos.
Why do I always overcomplicate things.
Thank you. You are a star!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
214 | |
84 | |
61 | |
61 | |
60 |