Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created a measure for a date field
Solved! Go to Solution.
@Anonymous
it looks like you have incorrect syntax.
try
CurrentTransCount =
(
VAR _Cuur_start = Min('Date'[Current Date])
VAR _Curr_END = Max('Date'[Current Date])
return
calculate(SUM(Final[TransCountnUm]), Final[Date] >= _Cuur_start, Final[Date] <= _Curr_END )
or
CurrentTransCount =
(
VAR _Cuur_start = Min('Date'[Current Date])
VAR _Curr_END = Max('Date'[Current Date])
return
calculate(SUM(Final[TransCountnUm]),FILTER(ALL(FInal),Final[Date] >= _Cuur_start && Final[Date] <= _Curr_END ))
Try like
Week_CurrentTransCount =
(
VAR _Max = MaxX('Date', 'Date'[Current Date])
VAR _Min = _Max -7
return
calculate(SUM(Final[count]),filter(all('Date'),'Date'[Current Date] >=_Min && 'Date'[Current Date] <= _Max ))
I would just do:
Week_CurrentTransCount =
VAR _Curr_start = Max('Date'[Current Date])
VAR _Curr_END = (_Curr_start - 5)
return
SUMX(FILTER(Final,Final[Date] >= _Curr_start && Final[Date] <= _Curr_END ),Final[count])
I am not able to get any data in my measure.Although it is correct syntax wise .
The measures i used for first 2 columns are working
@Anonymous
it looks like you have incorrect syntax.
try
CurrentTransCount =
(
VAR _Cuur_start = Min('Date'[Current Date])
VAR _Curr_END = Max('Date'[Current Date])
return
calculate(SUM(Final[TransCountnUm]), Final[Date] >= _Cuur_start, Final[Date] <= _Curr_END )
or
CurrentTransCount =
(
VAR _Cuur_start = Min('Date'[Current Date])
VAR _Curr_END = Max('Date'[Current Date])
return
calculate(SUM(Final[TransCountnUm]),FILTER(ALL(FInal),Final[Date] >= _Cuur_start && Final[Date] <= _Curr_END ))
User | Count |
---|---|
80 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |