Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Having a bit of difficulty figuring out how to create a chart based on "Facilities used."
Just a bit of background. Imagine you are trying to find out how many days a building (at a fairgrounds) is used throughout the year. I have Dairy Barn, Sheep Barn, and Horse Barn (for example). We have them set up as facility codes (DB, SB, HB). I want to make a chart to say how many days each facility was used using it's facility code (column in excel) and number of use days (another callumn in excel). The number in the "use days" column is a formula based off of start and end date (each have their own particular column). Does anyone have any info on this?
IFC - 3
DCH - 1
BRP, GLB - 2
BRP, WPV, SPV, CHP, IFC, PWY - 14
Here is an example of what I'm talking about. The 3 characters indicate a particular facility, separated by the commas. Each line is a particular event that uses either one or multiple buildings
Any help would be greatly appreciated
Solved! Go to Solution.
You may take a look at the post below.
You may take a look at the post below.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |