Migruji Spotfire Report do PowerBI Reportu. Pro jeden ze sloupců mám Spotfire case when dotaz, který chci převést na switch case DAX výraz. Začal jsem a myslím, že mám dobrou počáteční část dotazu, ale nejsem si jistý, jak sestavit zbytek dotazu. Zde jsou podrobnosti:<\/P>
Spotfire case when dotaz:<\/P>
CASE WHEN (<\/STRONG><\/P> [RefPointGroupCap] není null) NEBO (<\/STRONG><\/P> [MortgageGroupCap] není null) NEBO (<\/STRONG><\/P> [MPBGroupCap] není null) NEBO (<\/STRONG><\/P> [NCBGroupCap] není null) NEBO (<\/STRONG><\/P> [SRCGroupCap] není null) PAK <\/STRONG><\/P> <\/SPAN>"Y"<\/STRONG><\/P> <\/SPAN>& (if([RefPointGroupCap] je null,""," \/ " & [RefPointGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([MortgageGroupCap] je null,""," \/ " & [MortgageGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([MPBGroupCap] je null,""," \/ " & [MPBGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([NCBGroupCap] je null,""," \/ " & [NCBGroupCap]))<\/STRONG><\/P> <\/SPAN>& (If([SRCGroupCap] je null,""," \/ " & [SRCGroupCap]))<\/STRONG><\/P>KDYŽ (<\/STRONG><\/P> [RefPointGroupCap] je null) a (<\/STRONG><\/P> [MortgageGroupCap] je null) a (<\/STRONG><\/P> [MPBGroupCap] je null) a (<\/STRONG><\/P> [NCBGroupCap] je null) a (<\/STRONG><\/P> [SRCGroupCap] je null) PAK "N"<\/STRONG><\/P>KONEC<\/STRONG><\/P>Switch case dotaz, který jsem sestavil do poloviny:<\/P>Sloupec=<\/STRONG><\/P>SWITCH (<\/STRONG><\/P>TRUE (),<\/STRONG><\/P>NE(ISBLANK('F22_New_Cumulative_export (2)'[RefPointGroupCap])) ||<\/STRONG><\/P>NE(ISBLANK('F22_New_Cumulative_export (2)'[MortgageGroupCap])) ||<\/STRONG><\/P>NE(ISBLANK('F22_New_Cumulative_export (2)'[MPBGroupCap])) ||<\/STRONG><\/P>NE(ISBLANK('F22_New_Cumulative_export (2)'[NCBGroupCap])) ||<\/STRONG><\/P>NE(ISBLANK('F22_New_Cumulative_export (2)'[SRCGroupCap])) ,<\/STRONG><\/p>
"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"
))))))
Dejte mi vědět, pokud potřebujete další informace, děkuji za pomoc!<\/p>
