Split Half Years Into Quarters

[Mawriz]

Hi,

I am a biginner user of Power BI and I am not even sure if this is the right place to ask this question. But the problem is as shown in the  photo.

The data is in half years (ofcourse this data is huge but I am using just this one row to demonstrate). I want to divide the half years into quaters( I do not know how to go about it in either of power query or DAX).

[v-yingjl]

Hi @Mawriz ,

The new Date column's logic is like @ Mawriz mentioned to create:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCinNS80xMFLSUTIyMDLWN9c3BDJNDAwMlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Rate = _t, Date = _t, Tons = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Rate", type text}, {"Date", type date}, {"Tons", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "New Date", each {Date.AddMonths([Date], -3), [Date]}),
    #"Expanded New Date" = Table.ExpandListColumn(#"Added Custom", "New Date"),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded New Date",{"Date"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"New Date", type date}})
in
    #"Changed Type1"

But still not certain the logic that you want to calculate 44.44 and 43.95.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

Take a look at my answer to this similar question earlier today:
https://community.powerbi.com/t5/Power-Query/Repeat-quarterly-results-for-every-month/m-p/2252280

That same sort of logic should work except for the Tons part. How are you transforming 4000 into 44.44 and 43.95?