Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |