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.
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 |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |