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.
Hi all,
i have column frequency with values likes below
Frequency
WD1
WD2
WD3
WD4
WD5
WD6
WD7
Daily
Daily
Anytime
Anytime
from this i want to create a new column like NewTime
if values like below
all WD 1,2,3,4,56,7 as Monthly
Daily as daily
Anytime as Random
so my new column values will be
NewTime
Monthly
Daily
Random
can anyone help how to create this . Am new to PBI.
Best
Chanty
Solved! Go to Solution.
Perhaps:
Column =
SWITCH([Frequency],
"Daily","Daily",
"Anytime","Random",
"Monthly"
)
@Anonymous
Hi @Anonymous ,
Perhaps:
Column =
SWITCH([Frequency],
"Daily","Daily",
"Anytime","Random",
"Monthly"
)
@Anonymous
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |