cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Doing something wrong in the statement

The goal of this statement is to take the first Monday (flagged correctly), take the sum of the measure ONLY for that day and the simply divide by 10 so that by the last Friday the measure is zero. It's resetting on the next Monday back to the original, and I'm lost as to why.

Measure = var _date =SELECTEDVALUE('SprintDays'[Date])
var _first_mon  =MAXX( FILTER( ALLSELECTED('SprintDays') , 'SprintDays'[Date] <= _date && 'SprintDays'[Flag] <> BLANK()) ,[Date])
var _first_mon_value = CALCULATE( SUM('Burndown'[StoryPoints]) , 'SprintDays'[Date] =_first_mon)
var _minus=WEEKDAY(_date,2)-1
return
_first_mon_value - DIVIDE(_first_mon_value,10) * _minus

Flag =
var _cur_date = 'SprintDays'[Date]
var _t  = FILTER( 'SprintDays','SprintDays'[Column]= "Monday"  &&  'SprintDays'[Date] <= _cur_date)
var _rank =  IF( 'SprintDays'[Column]="Monday"  ,   COUNTROWS(_t) ,BLANK())
return
IF( ISODD(_rank),1,BLANK() )

Column = FORMAT([Date],"dddd")

1 ACCEPTED SOLUTION
Community Support

Hi , @singleton2787

I'm sorry,this is my mistable.

You can use this dax to solve your problem:

``````Measure = var _date =SELECTEDVALUE('Table1'[Date])
var _first_mon  =MAXX( FILTER( ALLSELECTED('Table1') , 'Table1'[Date] <= _date && 'Table1'[Flag] <> BLANK()) ,[Date])
var _first_mon_value = CALCULATE( SUM('Table1'[StortyPoints]) , 'Table1'[Date] =_first_mon)
var _minus=IF( DATEDIFF(_first_mon,_date  ,DAY)>=7 , DATEDIFF(_first_mon,_date  ,DAY)-2,DATEDIFF(_first_mon,_date  ,DAY))
var _weekday =WEEKDAY(_date,2)
return
IF(_weekday in {6,7},BLANK(),_first_mon_value - DIVIDE(_first_mon_value,9) * _minus)``````

The result is as follows:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Community Support

Hi , @singleton2787

I'm sorry,this is my mistable.

You can use this dax to solve your problem:

``````Measure = var _date =SELECTEDVALUE('Table1'[Date])
var _first_mon  =MAXX( FILTER( ALLSELECTED('Table1') , 'Table1'[Date] <= _date && 'Table1'[Flag] <> BLANK()) ,[Date])
var _first_mon_value = CALCULATE( SUM('Table1'[StortyPoints]) , 'Table1'[Date] =_first_mon)
var _minus=IF( DATEDIFF(_first_mon,_date  ,DAY)>=7 , DATEDIFF(_first_mon,_date  ,DAY)-2,DATEDIFF(_first_mon,_date  ,DAY))
var _weekday =WEEKDAY(_date,2)
return
IF(_weekday in {6,7},BLANK(),_first_mon_value - DIVIDE(_first_mon_value,9) * _minus)``````

The result is as follows:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.