Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I get my data from Mycrosoft Dynamics. How can I change the second and third columns below.
For the second is fequency:
if 100000 = quarterly
if 100001 = six-month
if 100002 = annually
For the 3rd column: Each number is a month.
How can I change
If =1 then January,
if =2, then February and so on....
Thanks!!!
Solved! Go to Solution.
You can add two columns like:
= Table.AddColumn(PriorStepOrTableName, "Frequency", each if [ax_reviewfrequency] = "10000000" then "quarterly" else if [ax_reviewfrequency] = "10000001" then "six-month" else "annually", type text)
= Table.AddColumn(PriorStepOrTableName, "Month Name", each Date.MonthName(#date(1, [ax_annualistheendof], 1)), type text)
--Nate
You can add two columns like:
= Table.AddColumn(PriorStepOrTableName, "Frequency", each if [ax_reviewfrequency] = "10000000" then "quarterly" else if [ax_reviewfrequency] = "10000001" then "six-month" else "annually", type text)
= Table.AddColumn(PriorStepOrTableName, "Month Name", each Date.MonthName(#date(1, [ax_annualistheendof], 1)), type text)
--Nate
@Erika16 Maybe calculated columns like:
Frequency Column =
SWITCH([ax_reviewfrequency],
100000,"quarterly",
100001,"six-month",
"annually"
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
24 | |
21 | |
21 | |
13 |