Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am importing data from SQL and have unpivoted some columns. The columns unpivoted were text columns that referenced the period by month. However the text used is in a rediculous format of FY_01, FY_02, etc. I want these displayed in visuals as month names, January, February, etc... I assume I need to make a new column that references the existing column and changes the text to the proper format. How do I do this? Or is their another way that is more logical?
Thanks
Solved! Go to Solution.
HI @snocaps248 ,
You can create a DUPLICATE column of your existing column and then follow the steps that I have suggested.
Thanks,
Pragati
Hi @snocaps248 ,
Try following steps:
Consider following column:
Go to Query Editor and extract after delimiter:
You will get following:
Modify column's data-type to WHOLE NUMBER:
Apply query settings.
Just create a new DAX column as -
You get the required result.
Thanks,
Pragati
If I make the changes to the existing column as you suggest, will that break the refresh of data? I have set this dataset to refresh from our on-prem sql nightly for it to update the dashboard for morning execs meeting.
Thanks,
HI @snocaps248 ,
You can create a DUPLICATE column of your existing column and then follow the steps that I have suggested.
Thanks,
Pragati
@snocaps248 - Well, you could write a nested if then else statement in Power Query or you could use a SWITCH statement in DAX like:
Month =
SWITCH([Period],
"FY_01","January",
"FY_02","February",
...
)
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |