Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

"How to Automatically Update Data with DAX Excluding Weekends"

Hi, I am new to the community, and I am learning to use Power BI. I want to create a report where the data is automatically updated with the previous day's data. In other words, if it is Tuesday, it...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    maybe you can try to create a flag column in date table 

     

    Column =
    var _last=maxx(FILTER('Table','Table'[date]<today()&&'Table'[Type]="L"),'Table'[date])
    return if ('Table'[date]<=_last,"y")
     
     
    and add this new column to filter and set the value to "y"
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Anonymous 

do you only want to update and display the last workday's data or update and include until last workday's data?

 

could you pls provide some sample data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Sorry for my English.
    I want to update and display until the previous last workday."I have this calendar where 'L' stands for workday and 'F' stands for holiday ."

     

     

     

     



    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      Anonymous 

      maybe you can try to create a flag column in date table 

       

      Column =
      var _last=maxx(FILTER('Table','Table'[date]<today()&&'Table'[Type]="L"),'Table'[date])
      return if ('Table'[date]<=_last,"y")
       
       
      and add this new column to filter and set the value to "y"