Forum Discussion

Mawriz's avatar
Mawriz
Frequent Visitor
4 years ago

Split Half Years Into Quarters

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).

Need Help

2 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    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.