Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AtchayaP
Helper V
Helper V

Powerbi

16558188158377193486351793158239.jpg

  I want to know dax syntax for calculating job range in PowerBI .  I have highlighted the column that is the answer should I need in PowerBI   @Vijay_A_Verma 

1 ACCEPTED SOLUTION

Hi @AtchayaP ,

 

It's the Power Query forum, we use the M language instead of the DAX language in the Power Query Editor.

They are different, you can refer to Differences between the M Language and DAX in Power BI.

The screenshot you provided is in the Power Query editor.

You can add the conditional column as

vstephenmsft_0-1656060022110.png

Here's the result.

vstephenmsft_1-1656060029450.png

You can go to the advanced editor to check you codes.

vstephenmsft_2-1656060079124.png

 

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Vijay_A_Verma
Super User
Super User

Use below DAX. Replace Range with your result column name and Years with your input column name

Range = 
SWITCH(TRUE(),
    [Years]>5,"5 years",
    [Years]>3,"3-5 years",
    [Years]>1,"1-3 years",
    "<1 year"
)

 

 Will this works,?

16558371403178707908006668186569.jpg

 

Hi @AtchayaP ,

 

It's the Power Query forum, we use the M language instead of the DAX language in the Power Query Editor.

They are different, you can refer to Differences between the M Language and DAX in Power BI.

The screenshot you provided is in the Power Query editor.

You can add the conditional column as

vstephenmsft_0-1656060022110.png

Here's the result.

vstephenmsft_1-1656060029450.png

You can go to the advanced editor to check you codes.

vstephenmsft_2-1656060079124.png

 

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors