Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello..,
if we have scenario like i have 3 years data.in that i want dates in single column like first year jan -nov,second year feb-oct,third year march-spt..
Thank you
Solved! Go to Solution.
Hi @manindes ,
Create a new Column
New Column =
Var __month = Month(Dates[Date])
Var __year = YEAR(Dates[Date])
RETURN
SWITCH(
TRUE(),
__year = 2015 && __month >=1 && __month <=11, "Jan - Nov" & " " & __year,
__year = 2016 && __month >=2 && __month <=10, "Feb - Oct" & " " & __year,
__year = 2017 && __month >=3 && __month <=9, "March - Sep" & " " & __year
)
Replace the 3 years with the years in ypur data.
Regards,
Harsh Nathani
Hi @manindes ,
Please share more information as to what is needed.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You should try creating a Date Table
Create a Date Table.
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Also, incase you want column in same table, then create a Column
New Column =
Var __month = FORMAT('Table'[Order Date]. "mmm")
Var __year = YEAR('Table'[Order Date])
RETURN
__month & __year
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Thanks for replay but it displaying error like
Too few arguments were passed to the FORMAT function. The minimum argument count for the function is 2
Hi @manindes ,
A typo mistake.
Try this
New Column =
Var __month = FORMAT(Dates[Date], "mmm")
Var __year = YEAR(Dates[Date])
RETURN
__month & " " & __year
Regards,
Harsh Nathani
thanks it's working but am looking like in above data
i have 3 years data.in that i want dates in single column like first year jan -nov,second year feb-oct,third year march-spt..
Hi @manindes ,
Create a new Column
New Column =
Var __month = Month(Dates[Date])
Var __year = YEAR(Dates[Date])
RETURN
SWITCH(
TRUE(),
__year = 2015 && __month >=1 && __month <=11, "Jan - Nov" & " " & __year,
__year = 2016 && __month >=2 && __month <=10, "Feb - Oct" & " " & __year,
__year = 2017 && __month >=3 && __month <=9, "March - Sep" & " " & __year
)
Replace the 3 years with the years in ypur data.
Regards,
Harsh Nathani
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
40 | |
20 | |
12 |