Forum Discussion
"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...
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"
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 ."
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"