Split Bi weekly data to weekly data?

[TolgaOzpirildak]

Hi all,

I am struggling with one calculation. I have a bi-weekly data and also weekending dates as a inducator. I want to divide this bi- weekly data to weekly data , and in that way I will have 2 equal weekly data. I mean every week-ending will have their own amount instead of bi-weekly and middle of the date will be auto generated by DAX. Is it possible to do that?

Thank you for your helps.

Regards

 

[parry2k · Accepted solution]

@TolgaOzpirildak with DAX you can new table using following code:

Weekly Data = 
VAR __WeeklyTable =
ADDCOLUMNS ( 
    GENERATE ( 
        BiWeekly,
        { 0, 1 }
    ),
    "Weekly Amount", [Amount] / 2,
    "Weekly Date", [Week Ending] - ( [Value] * 7 )
)
RETURN
SELECTCOLUMNS ( 
    __WeeklyTable,
    "Product", [Product],
    "Week Ending", [Weekly Date],
    "Amount", [Weekly Amount]
)

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️