analysis in excel

3 Topics

Dynamic formatting not showing the correct currency in Excel
Hi team, I am using the dynamic formatting for a switch measure to ensure to display the data in correct format according to the selected measure. It works all fine until I visualise the data in Excel. I get £ sign instead of $ sign. Here is the dynamic formatting code: SWITCH( TRUE(), [SelectedMeasure] = 1, "$#,##0", // Revenue [SelectedMeasure] = 2, "#,##0", // Units [SelectedMeasure] = 3, "#,##0", // Accounts [SelectedMeasure] = 4, "$#,##0", // ADS Revenue [SelectedMeasure] = 5, "#,##0", // ADS Units [SelectedMeasure] = 6, "$#,##0", // Revenue On Pace [SelectedMeasure] = 7, "#,##0", // Units On Pace [SelectedMeasure] = 8, "$#,##0", // ASP [SelectedMeasure] = 9, "#,##0", // Units / Account [SelectedMeasure] = 11, "0%", // IVL/PCI% [SelectedMeasure] = 12, "0%", // IVL/ROTA% [SelectedMeasure] = 13, "$#,##0", // Revenue (actual fx) [SelectedMeasure] = 14, "#,##0", // Units Coronary [SelectedMeasure] = 15, "#,##0", // Units Peripheral [SelectedMeasure] = 16, "#,##0", // Orders [SelectedMeasure] = 18, "$#,##0", // Revenue Coronary [SelectedMeasure] = 19, "$#,##0", // Revenue Peripheral [SelectedMeasure] = 20, "#,##0", // Units FOC [SelectedMeasure] = 21, "0%", // Units FOC % [SelectedMeasure] = 22, "0%", // C2/PCI% [SelectedMeasure] = 23, "0%", // C2/ROTA% "General" // Default format ) I tried adding FORMAT([SelectedMeasure]) but it returns wrong results. Kindly advise, Best regards, Hugo
Solved
treatas
1 year ago Place DAX Commands and Tips
1.2KViews
0likes
2Comments
Is there any method to avoid rebuilding excel pivot migrating from SSAS MOLAP Cube to Tabular Cube?
Dear Experts, Please advise is there any method to migrate all our excel pivot reports (Live Connection Reports) from SSAS MOLAP Cube to SSAS Tabular Cube as we are moving Azure Anlaysis Service?
Solved
KoppulaPSR
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
6Comments
Pivot Table Target Measure
Hi guys... I need your help with a measure in Pivot Table with Excel. My goal is to have a measure (DisplayTotalWeeks) based on qty of "SemanaMes". In the case, it must return 9 like the example below. Something like that: Criada em (Month) SemanaMes Qty Atividade DisplayTotalWeeks abr 1 446 9 abr 2 11 9 abr 3 1 9 abr 4 3 9 abr 5 1 9 mai 1 524 9 mai 2 701 9 mai 3 1 9 mai 4 2 9 Grand Total 1690 9 I have stressed ChatGPT, but it doesn't give me what I'm looking for. As an example, I have try this from GPT: TotalUniqueWeeks := COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[SemanaMes])) DisplayTotalWeeks := CALCULATE([TotalUniqueWeeks], ALL('YourTable')) It doesn't return 9, that what I was expecting. So, you are my last hope.
Anonymous
2 years ago Place DAX Commands and Tips
1KViews
0likes
4Comments