Forum Discussion

MA_NetworkRail's avatar
MA_NetworkRail
New Member
2 years ago

Error - 13 Periods in the Financial Year

Hi,   I'm hoping someone can assist me with a date issue in PowerBI (I am a beginner to PowerBI).   For some context, I am putting together a simple dashboard with a few line graphs showing how t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MA_NetworkRail ,

Should the 13th Periods be considered as the 1st Periods of the following year? 
If so, please try:

 

let 
period = Number.ToText([Period]), year = Text.Start(period, 4), 
month = Text.End(period, 2) 
in 
if month = "13" 
then Date.FromText(Text.From(Number.FromText(year) + 1) & "01" & "01", "de-DE") 
else Date.FromText(year & month & "01", "de-DE")

Output:

 

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum