Forum Discussion
Analitika
Post Prodigy
Post ProdigyExclude weekend from date column in Power BI
Hello, I need to ask how I could exclude weekends from date column, leaving date only weekday. Here is dax of date column: Calendar = ADDCOLUMNS ( CALENDAR ( DATE ( min ('_Year BRIDGE'[Y...
Hi Analitika
Try to add a visual level filter by using a measure:
Measure = IF(MAX('Calendar'[WeekdayNo])<>6&&MAX('Calendar'[WeekdayNo])<>7,1)Set show items when the value is 1.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
