Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Wave | Company ID | Weights | Questions | Answers | Weighted Answers | Periods |
1 | 1 | 0,006 | Demand change compared to the previous 6 months | -1 | -0,006 | 2022 H2 |
1 | 1 | 0,006 | Expected change in demand in the next 6 months | 1 | 0,006 | 2023 H1 |
1 | 1 | 0,006 | Liquidity problems intensity | 1 | 0,006 | 2022 H2 |
1 | 1 | 0,006 | Expected change in employment | 0 | 0 | 2023 H1 |
1 | 2 | 0,001 | Demand change compared to the previous 6 months | 1 | 0,001 | 2022 H2 |
1 | 2 | 0,001 | Expected change in demand in the next 6 months | 1 | 0,001 | 2023 H1 |
1 | 2 | 0,001 | Liquidity problems intensity | -1 | -0,001 | 2022 H2 |
1 | 2 | 0,001 | Expected change in employment | 1 | 0,001 | 2023 H1 |
1 | 3 | 0,0057 | Demand change compared to the previous 6 months | 1 | 0,0057 | 2022 H2 |
1 | 3 | 0,0057 | Expected change in demand in the next 6 months | 0 | 0 | 2023 H1 |
1 | 3 | 0,0057 | Liquidity problems intensity | 0 | 0 | 2022 H2 |
1 | 3 | 0,0057 | Expected change in employment | 0 | 0 | 2023 H1 |
2 | 1 | 0,006 | Demand change compared to the previous 6 months | 1 | 0,006 | 2023 H1 |
2 | 1 | 0,006 | Expected change in demand in the next 6 months | 0 | 0 | 2023 H2 |
2 | 1 | 0,006 | Liquidity problems intensity | 0 | 0 | 2023 H1 |
2 | 1 | 0,006 | Expected change in employment | 0 | 0 | 2023 H2 |
2 | 2 | 0,001 | Demand change compared to the previous 6 months | 1 | 0,001 | 2023 H1 |
2 | 2 | 0,001 | Expected change in demand in the next 6 months | 1 | 0,001 | 2023 H2 |
2 | 2 | 0,001 | Liquidity problems intensity | -1 | -0,001 | 2023 H1 |
2 | 2 | 0,001 | Expected change in employment | 1 | 0,001 | 2023 H2 |
2 | 3 | 0,0057 | Demand change compared to the previous 6 months | 1 | 0,0057 | 2023 H1 |
2 | 3 | 0,0057 | Expected change in demand in the next 6 months | 0 | 0 | 2023 H2 |
2 | 3 | 0,0057 | Liquidity problems intensity | -1 | -0,0057 | 2023 H1 |
2 | 3 | 0,0057 | Expected change in employment | 1 | 0,0057 | 2023 H2 |
*Weighted Answers is calculated as: Weights * Answers
**In the column "Answers" -1 denotes decrease (or zero problems for Liquidity problems intensity), 0 denotes stability (or low to medium intensity problems), and 1 denotes increase (or high intensity problems).
Period =
IF(
'TableBI'[Wave] = 1,
IF(
('TableBI'[Questions] = "Demand change compared to the previous 6 months" ||
'TableBI'[Questions] = "Liquidity problems intensity"),
"2022 H2",
"2023 H1"
),
IF(
'TableBI'[Wave] = 2,
IF(
('TableBI'[Questions] = "Demand change compared to the previous 6 months" ||
'TableBI'[Questions] = "Liquidity problems intensity"),
"2023 H1",
"2023 H2"
)
)
)
)
***There are multiple waves in the original data
@atziovara , Based on what I got. Create a common date table and join it with both tables on date and use common table in visual, slicer and measure
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Wave | Company ID | Weights | Questions | Answers | Weighted Answers | Periods |
1 | 1 | 0,006 | Demand change compared to the previous 6 months | -1 | -0,006 | 2022 H2 |
1 | 1 | 0,006 | Expected change in demand in the next 6 months | 1 | 0,006 | 2023 H1 |
1 | 1 | 0,006 | Liquidity problems intensity | 1 | 0,006 | 2022 H2 |
1 | 1 | 0,006 | Expected change in employment | 0 | 0 | 2023 H1 |
1 | 2 | 0,001 | Demand change compared to the previous 6 months | 1 | 0,001 | 2022 H2 |
1 | 2 | 0,001 | Expected change in demand in the next 6 months | 1 | 0,001 | 2023 H1 |
1 | 2 | 0,001 | Liquidity problems intensity | -1 | -0,001 | 2022 H2 |
1 | 2 | 0,001 | Expected change in employment | 1 | 0,001 | 2023 H1 |
1 | 3 | 0,0057 | Demand change compared to the previous 6 months | 1 | 0,0057 | 2022 H2 |
1 | 3 | 0,0057 | Expected change in demand in the next 6 months | 0 | 0 | 2023 H1 |
1 | 3 | 0,0057 | Liquidity problems intensity | 0 | 0 | 2022 H2 |
1 | 3 | 0,0057 | Expected change in employment | 0 | 0 | 2023 H1 |
2 | 1 | 0,006 | Demand change compared to the previous 6 months | 1 | 0,006 | 2023 H1 |
2 | 1 | 0,006 | Expected change in demand in the next 6 months | 0 | 0 | 2023 H2 |
2 | 1 | 0,006 | Liquidity problems intensity | 0 | 0 | 2023 H1 |
2 | 1 | 0,006 | Expected change in employment | 0 | 0 | 2023 H2 |
2 | 2 | 0,001 | Demand change compared to the previous 6 months | 1 | 0,001 | 2023 H1 |
2 | 2 | 0,001 | Expected change in demand in the next 6 months | 1 | 0,001 | 2023 H2 |
2 | 2 | 0,001 | Liquidity problems intensity | -1 | -0,001 | 2023 H1 |
2 | 2 | 0,001 | Expected change in employment | 1 | 0,001 | 2023 H2 |
2 | 3 | 0,0057 | Demand change compared to the previous 6 months | 1 | 0,0057 | 2023 H1 |
2 | 3 | 0,0057 | Expected change in demand in the next 6 months | 0 | 0 | 2023 H2 |
2 | 3 | 0,0057 | Liquidity problems intensity | -1 | -0,0057 | 2023 H1 |
2 | 3 | 0,0057 | Expected change in employment | 1 | 0,0057 | 2023 H2 |
*Weighted Answers is calculated as: Weights * Answers
**In the column "Answers" -1 denotes decrease (or zero problems for Liquidity problems intensity), 0 denotes stability (or low to medium intensity problems), and 1 denotes increase (or high intensity problems).
Period =
IF(
'TableBI'[Wave] = 1,
IF(
('TableBI'[Questions] = "Demand change compared to the previous 6 months" ||
'TableBI'[Questions] = "Liquidity problems intensity"),
"2022 H2",
"2023 H1"
),
IF(
'TableBI'[Wave] = 2,
IF(
('TableBI'[Questions] = "Demand change compared to the previous 6 months" ||
'TableBI'[Questions] = "Liquidity problems intensity"),
"2023 H1",
"2023 H2"
)
)
)
)
***There are multiple waves in the original data
User | Count |
---|---|
93 | |
85 | |
76 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |