Hi this is what I have so far
Go to Solution.
BalanceScore = IF(
'Math'[Shift1]='Math'[Shift2] && 'Math'[Shift2]='Math'[Shift3] && 'Math'[Shift3]='Math'[Shift4] && 'Math'[Shift4]='Math'[Shift5],
View solution in original post
[Shift3] = [Shift4],
[Shift4] = [Shift5]
[Shift1] = [Shift2],
[Shift3] = [Shift4]
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
You can use && instead of AND().
BalanceScore = Switch( True(),
[Shift1]=[Shift2] && [Shift1]=[Shift3] && [Shift1]=[Shift4] && [Shift1]=[Shift5]) , 3,
But It is not necessary to use Switch, you use switch when you want more 2 results.
BalanceScore = IF([Shift1]=[Shift2] && [Shift1]=[Shift3] && [Shift1]=[Shift4] && [Shift1]=[Shift5]), 3 ,1)
How to use Swtich: https://docs.microsoft.com/en-us/dax/switch-function-dax
Paul Zheng _ Community Support TeamIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, it worked!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.