Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)
edited by

 I have a table

Order Date         team  count
1      Jan-20      A     6
2      Feb-20      A     7
3      Feb-20      B     10
4      Mar-20      A     8
:
80     Dec-20      A      12
How do I get orders from Jan-Dec

1 Answer

0 votes
by (22.5k points)
edited by

Use the following measure

Month = LEFT([Date], 3)

which gives a result like this

Month | Sort
Jan   | 1
Feb   | 2
... 

Dec | 12 

Are you willing to learn power bi, Check the Power Bi Developer provided by Intellipaat

Also, watch our YouTube video on Power BI Courses to get yourself started.

Related questions

0 votes
1 answer
asked Dec 24, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 30, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jan 14, 2021 in BI by Chris (11.1k points)

Browse Categories

...