Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
my name is Filip/Poland. I am new at Power BI enviroment.
I have to prepare for my company some dashboard raports.
I want to calculate days of raporting without weekends.
I am using function:
Help you for help 🙂 Can you tell me, why I can use functions like datedif (works with calendar) and cant use functions like calendar (also works with calendar)?
What is the relationship between the table used by [End of Inspection] and your calendar table? It should be a 1 directional, one to many, from Calendar to your data.
Then build your measure, and one the Filters pane for that visual, drag in the "Day of Week" field from your calendar, select all apart from 6 & 7. That will do it if your relationship is right.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |