Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display data for Monday every week.

Requirement is to display data only for Monday for entire week. Next week, it should again reflect values for Monday this week only. for example : Today is 12th May, Wednesday but report should refl...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Create 2 columns as below:

    Weeknum = WEEKNUM('Table'[Date],2)
    First Monday = 
var _mindate=CALCULATE(MIN('Table'[Date]),FILTER('Table','Table'[Weeknum]=EARLIER('Table'[Weeknum])))
var _weekday=WEEKDAY(_mindate,2)
Return
IF(_weekday<>1,DATE(YEAR(_mindate)-1,12,31-(_weekday-1)+1),_mindate)

    And you will see:

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , One way is to create a column in date table and default on that

 

Date Type =
var _1 = today() +-1*WEEKDAY(today() ,2)+1
return
SWITCH(TRUE(),'Date'[Date]=_1,"Last Monday"
,'Date'[Date]&"")

 

or create a measure like 

 

measure =

var _min = minx(allselected('Date1'), Date1[Date])
var _max = today() +-1*WEEKDAY(today() ,2)+1
return
calculate(Sum('Table'[Value]), filter('Date', 'Date'[Date] <=_max && 'Date'[Date] >=_min ))

 

 

Refer for Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35