Forum Discussion
Rolling outbound DAX Issue
hi Experts amitchandak
below is my line graph and the blue one is creating issue
and for the same i have the measure
please note that SHIPPING_CONTAINER[End of Month] and 'OutbundDates(Disconnected)M'[End of Month] has not active relationship, as i cannot create a physical relationship like one to many, i have used Userrelationship function
may be something wrong in how i am doing it? please help
outbound EOM is working fine, here is how the dax is created
1 Reply
vinodDrinkPak , Not very clear. But You need at least one Date table. Connected with both tables. seem like two tables.
You might need an independent/disconnected date table. if you want to select on date and want to display a trend
//Date1 is independent Date table and Date is Joined to table 1
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -6) +1 // for 6 month trend
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))//Date1 is independent Date table and Date is Joined to Table2
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -6) +1 // for 6 month trend
return
calculate( sum(Table2[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaIn case you same table with two dates
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUContinue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f
