Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am stucked while calculating sales with different conditions. Let me explain in detail
I have a calendar table and a Sales table, and looking for a dax where if i am selecting any date using calendar date which is not equal to current data then the dax should calculate sales where the selected date should less than or equal to posting date and selected date is greater than Clearing date. and Condition type = BSAD (Note:- Posting date & Clearing date & Condition Type are 3 different columns in Sales Table).
Thanks in advance.
Solved! Go to Solution.
@jay_patel , Try a measure like
Measure =
var _max = maxx(allselected('Date1'),'Date1'[Date])
var _m = Calculate(sum(Table[Value]), filter(Table, Table[Posting Date] >=_max && Table[Cleaning Date] <=_max && [Condition type] = "BSAD"))
return
if(isblank(sum(Table[Value])), _m, sum(Table[Value]))
or
If date tble is joined
Measure =
var _max = maxx(allselected('Date1'),'Date1'[Date])
var _m = Calculate(sum(Table[Value]), filter(all(Table), Table[Posting Date] >=_max && Table[Cleaning Date] <=_max && [Condition type] = "BSAD"))
return
if(isblank(sum(Table[Value])), _m, sum(Table[Value]))
Hi jay,
now i am facing same issue with vendors data,
please consider the below text.
(Hi all,
I am stucked while calculating sales with different conditions. Let me explain in detail
I have a calendar table and a Sales table, and looking for a dax where if i am selecting any date using calendar date which is not equal to current data then the dax should calculate sales where the selected date should less than or equal to posting date and selected date is greater than Clearing date. and Condition type = BSAD (Note:- Posting date & Clearing date & Condition Type are 3 different columns in Sales Table).)
@jay_patel , Try a measure like
Measure =
var _max = maxx(allselected('Date1'),'Date1'[Date])
var _m = Calculate(sum(Table[Value]), filter(Table, Table[Posting Date] >=_max && Table[Cleaning Date] <=_max && [Condition type] = "BSAD"))
return
if(isblank(sum(Table[Value])), _m, sum(Table[Value]))
or
If date tble is joined
Measure =
var _max = maxx(allselected('Date1'),'Date1'[Date])
var _m = Calculate(sum(Table[Value]), filter(all(Table), Table[Posting Date] >=_max && Table[Cleaning Date] <=_max && [Condition type] = "BSAD"))
return
if(isblank(sum(Table[Value])), _m, sum(Table[Value]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |