Split Bi weekly data to weekly data?

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! ❤️