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.
I have a query. Please help!
I have 2 columns (X and Y) with 10 rows each.
1. In X column top 4 rows are blank and rest 6 rows have values.
"X" Column Values: [Blank, Blank, Blank, Blank, 34,56,76,87,98,98]
2. In Y column top 2 rows are blank and rest of the rows have values.
"Y" Column Values: [Blank, Blank, 233, 333, 334, 456, 5765, 58, 5598, 6798]
Now as per the requirement, I need a calculated column Named "XYZ",
this column needs to be populated by the count of values in each row of both columns X and Y
"XYZ" Column Values: [0, 0, 1, 1, 2, 2, 2, 2, 2, 2]
Hi @gaurav1991
Please try this calculated column
XYZ = SWITCH( TRUE() , ISBLANK('Table1'[X]) = true && ISBLANK('Table1'[Y]) = TRUE , 0 , ISBLANK('Table1'[X]) = false && ISBLANK('Table1'[Y]) = FALSE , 2 , --ELSE-- 1 )
Hello Phil,
I can't hard code the columns as column X and Y are actually the month's name and that will varies as the new sales data will be uploaded.
Actual Case, Its quarterly sales data, Month's names are used in columns after pivoting the data. I just need a dynamic function in which I don't need to hardcode the column name as that would be changed in next quarter.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |