Forum Discussion

RickWelfel's avatar
RickWelfel
New Member
5 years ago
Solved

Table formatting

I have a table that shows data based on date range, is there a way to highlight or bold the date that is in a current week? 

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi RickWelfel 

    create the measure and put it in Background color of Values you want,

    conditional format = 
VAR _today =
    TODAY () // get current date
VAR _oneweekago =LASTDATE(CALCULATETABLE(DATEADD ( 'date'[Date], -7, DAY ),ALL('date')))//get the date one week ago, e.g. today= 2021/6/21, then _oneweekago=2021/6/14
RETURN
    IF (
        MIN ( 'date'[Date] ) >= _oneweekago
            && MIN ( 'date'[Date] ) <= _today,
        "Yellow"
    )

    result:

    See sample file attached bellow.

     

     

    Best Regards,

    Community Support Team _ Tang

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

6 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    Hi RickWelfel 

    create the measure and put it in Background color of Values you want,

    conditional format = 
VAR _today =
    TODAY () // get current date
VAR _oneweekago =LASTDATE(CALCULATETABLE(DATEADD ( 'date'[Date], -7, DAY ),ALL('date')))//get the date one week ago, e.g. today= 2021/6/21, then _oneweekago=2021/6/14
RETURN
    IF (
        MIN ( 'date'[Date] ) >= _oneweekago
            && MIN ( 'date'[Date] ) <= _today,
        "Yellow"
    )

    result:

    See sample file attached bellow.

     

     

    Best Regards,

    Community Support Team _ Tang

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

    • RickWelfel's avatar
      RickWelfel
      New Member
      5 years ago

      Thanks for the help. I am still having issues with typing VAR_Today,  this is giving me an error. 

  • RickWelfel's avatar
    RickWelfel
    New Member
    5 years ago

    I was able to get the formula working but giving me a MIN function only accpets a column reference as an argument. 

     

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      5 years ago

      Hi RickWelfel 

      in my sample, 

       MIN ( 'date'[Date] )

      'date'[Date] is a column.

      what do you put in function Min()?😅

       

      Best Regards,

      Community Support Team _ Tang

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

      • RickWelfel's avatar
        RickWelfel
        New Member
        5 years ago

        This is what I am trying to state: 

        current week =
        VAR _today =
        TODAY () // get current date
        VAR _oneweekago =LASTDATE(CALCULATETABLE(DATEADD ( 'Combined Schedule'[Start].[Date], -7, DAY ),ALL('Combined Schedule'[Start].[Date])))//get the date one week ago, e.g. today= 2021/6/21, then _oneweekago=2021/6/14
        RETURN
        IF (
        MIN ( 'Combined Schedule'[Start].[Date] ) >= _oneweekago
        && MIN ( 'Combined Schedule'[Start].[Date]] ) <= _today,
        "Yellow"
        )))))))
         
         
         
        Now its giving me an error of "The end of the input was reached".