Forum Discussion

lovelylemon's avatar
lovelylemon
New Member
1 year ago
Solved

Power BI Text to Date conversion - Extreme newbie

Hi All,   I have tried my best to figure this out (many hours), read many pages and I still cannot get this right, please could I get some help. I am new to Power BI.   I want to convert the orgi...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    The lowest form of data I have on the origial data is "2024 Q1"

    Add a Date column to your data, for example the first day of that quarter.  Use the Date column to join to the calendar table.

lovelylemon's avatar
lovelylemon
New Member
1 year ago

I would just like to say, I solved it using a combination of all the work ive seen to date, to reference, I ended up doing the following;

"

Date format =
Var _Y = value(Left('FILE PATH'[Fiscal Quarter], 4))
Var _d = 1
Var _QTR =
switch (value(right('File Path'[Fiscal Quarter], 1)), 1, 1, 2, 4, 3, 7, 4, 10)
RETURN
Date ( _y, _QTR, _d)"

Thanks for your support either way
v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi lovelylemon,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you for confirming that the issue is resolved. I request you to please accept this post as "Accept as Solution", so that other community members who has the similar issue will find it more quickly.

 

Thanks and regards,

Anjan Kumar Chippa