SpotfireレポートをPowerBIレポートに移行しています。ある列について、Spotfireのcase whenクエリをswitch caseのDAX式に変換したいと考えています。最初の部分はうまくできたと思いますが、残りのクエリの構築方法がわかりません。詳細は以下の通りです：<\/P>
Spotfireのcase whenクエリ：<\/P>
CASE WHEN (<\/STRONG><\/P> [RefPointGroupCap] がnullでない) または (<\/STRONG><\/P> [MortgageGroupCap] がnullでない) または (<\/STRONG><\/P> [MPBGroupCap] がnullでない) または (<\/STRONG><\/P> [NCBGroupCap] がnullでない) または (<\/STRONG><\/P> [SRCGroupCap] がnullでない) ならば <\/STRONG><\/P> <\/SPAN>"Y"<\/STRONG><\/P> <\/SPAN>& (if([RefPointGroupCap] がnullなら""," \/ " & [RefPointGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([MortgageGroupCap] がnullなら""," \/ " & [MortgageGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([MPBGroupCap] がnullなら""," \/ " & [MPBGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([NCBGroupCap] がnullなら""," \/ " & [NCBGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([SRCGroupCap] がnullなら""," \/ " & [SRCGroupCap]))<\/STRONG><\/P>WHEN (<\/STRONG><\/P> [RefPointGroupCap] がnull) かつ (<\/STRONG><\/P> [MortgageGroupCap] がnull) かつ (<\/STRONG><\/P> [MPBGroupCap] がnull) かつ (<\/STRONG><\/P> [NCBGroupCap] がnull) かつ (<\/STRONG><\/P> [SRCGroupCap] がnull) ならば "N"<\/STRONG><\/P>END<\/STRONG><\/P>途中まで作成したswitch caseクエリ：<\/P>Column=<\/STRONG><\/P>SWITCH (<\/STRONG><\/P>TRUE (),<\/STRONG><\/P>NOT(ISBLANK('F22_New_Cumulative_export (2)'[RefPointGroupCap])) ||<\/STRONG><\/P>NOT(ISBLANK('F22_New_Cumulative_export (2)'[MortgageGroupCap])) ||<\/STRONG><\/P>NOT(ISBLANK('F22_New_Cumulative_export (2)'[MPBGroupCap])) ||<\/STRONG><\/P>NOT(ISBLANK('F22_New_Cumulative_export (2)'[NCBGroupCap])) ||<\/STRONG><\/P>NOT(ISBLANK('F22_New_Cumulative_export (2)'[SRCGroupCap])) ,
"Y" &&
(IF(ISBLANK('F22_New_Cumulative_export (2)'[RefPointGroupCap]), BLANK(), " \/ " & 'F22_New_Cumulative_export (2)'[RefPointGroupCap]) &&
(IF(ISBLANK('F22_New_Cumulative_export (2)'[MortgageGroupCap]), BLANK(), " \/ " & 'F22_New_Cumulative_export (2)'[MortgageGroupCap]) &&
(IF(ISBLANK('F22_New_Cumulative_export (2)'[MPBGroupCap]), BLANK(), " \/ " & 'F22_New_Cumulative_export (2)'[MPBGroupCap]) &&
(IF(ISBLANK('F22_New_Cumulative_export (2)'[NCBGroupCap]), BLANK(), " \/ " & 'F22_New_Cumulative_export (2)'[NCBGroupCap]) &&
(IF(ISBLANK('F22_New_Cumulative_export (2)'[SRCGroupCap]), BLANK(), " \/ " & 'F22_New_Cumulative_export (2)'[SRCGroupCap]),
ISBLANK('F22_New_Cumulative_export (2)'[RefPointGroupCap]) ||
ISBLANK('F22_New_Cumulative_export (2)'[MortgageGroupCap]) ||
ISBLANK('F22_New_Cumulative_export (2)'[MPBGroupCap]) ||
ISBLANK('F22_New_Cumulative_export (2)'[NCBGroupCap]) ||
ISBLANK('F22_New_Cumulative_export (2)'[SRCGroupCap]),
"N"
))))))
追加情報が必要な場合はお知らせください。ご協力ありがとうございます！
