Forum Discussion

HR303's avatar
HR303
Frequent Visitor
2 years ago
Solved

DAX: Distributing values from one column into multiple colums

Hi all,

 

I need to distribute values from one column into multiple columns with DAX. I have "Order Value" in the Input table for a date range between the "Order Start date" and "Order End Date". 

 

In my DAX Query I want to distribute the "Order Value" in the month of the date range and the show the monthly sum of the broken down "Order Values".

Here is the example:


Does somebody have an idea how to tackle this in DAX?

Thx!

2 Replies