Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I need to convert the financial period into calender date. Example : 2020101 to 202007
That would be great if any of you could help me with the DAX formula that I can use....
Thanks,
Melissa
@Anonymous , Try a new column like
Calendar period =
var _year =left([FY Period],4)
var _pp =right([FY Period],2)
return
if(_pp<=6 , (_year -1) & (_pp+6) , _year & (_pp-6))
I am getting this error:
DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Thanks for your reply, I have the FY period and I want to creat calender period.
@Anonymous , not very clear.
You can create date from it
date = date(left([col],4), right([col],2),1)
Refer to my blog on how to get FY for each month : Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
Video: https://www.youtube.com/watch?v=euIC0dgGTNM
Can you share sample data and sample output in table format?
User | Count |
---|---|
50 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
63 | |
28 | |
18 | |
13 |