Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |