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.
HI,
I'm trying to connect one fact table (consumption data by hour ) with another table with different labels according to month & hour. It's like: "My consumption of 01:00-02:00 PM must be classified according to mounth & hour. With the table 2 I can labelled It."
May I make a Calendar (Dim table) & HOUR(Dim table)?
Yours sincerely,
TeraMaster.
Solved! Go to Solution.
Yes, you can create a Calendar (Dimension) table and an Hour (Dimension) table to help with labeling and classifying your consumption data based on month and hour.
Here's how you can create these tables:
Calendar (Dimension) table:
Hour (Dimension) table:
Once you have these Dimension tables set up, you can establish relationships between them and your Consumption (Fact) table. The Calendar table will be linked to the date column in your Consumption table, while the Hour table can be linked to the hour or time column in your Consumption table.
By creating these Dimension tables and establishing relationships, you can use the attributes from the Calendar and Hour tables to label and classify your consumption data based on month and hour in your visualizations and calculations.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Yes, you can create a Calendar (Dimension) table and an Hour (Dimension) table to help with labeling and classifying your consumption data based on month and hour.
Here's how you can create these tables:
Calendar (Dimension) table:
Hour (Dimension) table:
Once you have these Dimension tables set up, you can establish relationships between them and your Consumption (Fact) table. The Calendar table will be linked to the date column in your Consumption table, while the Hour table can be linked to the hour or time column in your Consumption table.
By creating these Dimension tables and establishing relationships, you can use the attributes from the Calendar and Hour tables to label and classify your consumption data based on month and hour in your visualizations and calculations.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thanks a lot for clarifying my mind. That's a good point.
Let me ask you some lines: In the case we've got our Consumption table connected to both Calendar table & Hour table, is any form for connecting our fact table with the Labels table?
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |