Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
First of all sorry for my english. I have two columns, one of them with different years and another one with quarters and i want to create a new column with date. For example:
Year Quarter Date (this is the column I want)
2018 1 01/01/2018
2017 2 01/04/2017
2016 4 01/10/2016
Is there any way to do this?
Thanks in advance!!!
Solved! Go to Solution.
@94veiga
Add this as a new column:
Date = DATE([Year], SWITCH( [Qtr], 1, 1, 2, 4, 3, 7, 4, 10) , 1 )
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@94veiga
Add this as a new column:
Date = DATE([Year], SWITCH( [Qtr], 1, 1, 2, 4, 3, 7, 4, 10) , 1 )
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you very much for your time!! I really aprecciate it!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |