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,
Please help..!
Need help with calculating "last3WeeksTotal" based on the selected Weekending date in the slicer. The formula I provided is showing blank results:
I have applied below DAX but it showing blank result :-
Report link below:
https://www.dropbox.com/s/6jvwyryae34ormg/3Weeks%20Total%20issue.pbix?dl=0
Any suggestions or corrections are welcome!
Solved! Go to Solution.
pls try this
3Wkstotal =
VAR _dateselected = [Selected_date]
VAR _Results =//Monday = 2,Tuesday = 3, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7
CALCULATE(
SUM('Date_set'[Revenue]),
('Date_set'[Order Stage] ,
'Date_set'[Scope]) in {( "Ordered","Order")}, REMOVEFILTERS(CalendarDate), DATESBETWEEN('CalendarDate'[Date], _dateselected-27,_dateselected-7))
RETURN
_Results
-----------------or --------------
3Wkstotal =
VAR _dateselected = [Selected_date]
VAR _Results =//Monday = 2,Tuesday = 3, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7
CALCULATE(
SUM('Date_set'[Revenue]),
('Date_set'[Order Stage] ,
'Date_set'[Scope]) in {( "Ordered","Order")}, DATESBETWEEN('CalendarDate'[Date], _dateselected-27,_dateselected-7))
RETURN
_Results
pls try this
3Wkstotal =
VAR _dateselected = [Selected_date]
VAR _Results =//Monday = 2,Tuesday = 3, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7
CALCULATE(
SUM('Date_set'[Revenue]),
('Date_set'[Order Stage] ,
'Date_set'[Scope]) in {( "Ordered","Order")}, REMOVEFILTERS(CalendarDate), DATESBETWEEN('CalendarDate'[Date], _dateselected-27,_dateselected-7))
RETURN
_Results
-----------------or --------------
3Wkstotal =
VAR _dateselected = [Selected_date]
VAR _Results =//Monday = 2,Tuesday = 3, Wednesday = 3, Thursday = 4, Friday = 5, Saturday = 6, Sunday = 7
CALCULATE(
SUM('Date_set'[Revenue]),
('Date_set'[Order Stage] ,
'Date_set'[Scope]) in {( "Ordered","Order")}, DATESBETWEEN('CalendarDate'[Date], _dateselected-27,_dateselected-7))
RETURN
_Results
@Ahmedx Thank you so much, I am about to accept this as solution however i have just a little query, we are summing revenue currentrly right, but if I want to apply average function. it shows wrong result.
How we can achive 4552 when we use Average funtion instead of sum. Please suggest.
it's complicated, but try writing another measure like this
fexed =
var _tbl =
SUMMARIZE('Date_set','Date_set'[Business Unit])
RETURN
SUMX(_tbl,[3WksAvgNew])
Thi @Ahmedx Thank you for replying!
But it is showing blank after applying this measure.! as It seems too comlicated. Thanks for trying!
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |