Forum Discussion
Split Bi weekly data to weekly data?
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
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! ❤️
1 Reply
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! ❤️