The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi All
I am doing append , so i cannot use PQ to recode , as DAX i can just paste the code.
Solved! Go to Solution.
@Paulyeo11
When you make a transformation in PQ, the steps will be applied whenever you load or refresh data. You do not need to repeat this process. However, if you need to do it in DAX, then, you shoudl create a an additional conditional column as follows:
New Column =
SWITCH(
[Column with number],
1 , "30 Days",
2, "60 days"
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Paulyeo11
When you make a transformation in PQ, the steps will be applied whenever you load or refresh data. You do not need to repeat this process. However, if you need to do it in DAX, then, you shoudl create a an additional conditional column as follows:
New Column =
SWITCH(
[Column with number],
1 , "30 Days",
2, "60 days"
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Sir
In that case i need to do at PQ. thank you for sharing.
Does it mean that if i add new column in PQ , and when i append 2 table , the column will stay ? As when i as column in DAX , after i append the column missing
Didn't get the question right but if you want to replace those numbers with your own text, you can do it in power query using Replace Value. Right-Click on the column, select Replace Value and enter "30 Days" for example for number 1. Repeat for the numbers as well.
________________________
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
Hi Fowmy
I already know how to recode using PQ.
I need to learn how to recode using DAX.
Because now i try to learn append , and if i do in PQ , every time i need to manually do again and again, if i have DAX script , i can just copy and paste
Paul
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
153 | |
137 | |
131 | |
81 | |
61 |