Comparison of the amount of sales in 2 arbitrary time periods in SSAS _ Cube
Hello Have a nice time I am connected to Sales Cube through Power BI via live connection I want to compare the amount of sales in two desired time periods through Slicer. I have the sales amount column and I also have the date table What should I do to make Comparison Sales Amount and 'Comparison Date'? Like the picture belowHelp me translate this MDX into DAX for creating a measure in power BI.
Hey there, please help me translate this MDX into DAX for creating a measure in power BI. I am new in Power BI and I was assigned to translate this MDX script to create measure in power BI. The MDX is as follows; CREATE MEMBER CURRENTCUBE.[Measures].[EmT] AS IIF(([Units Of Measure].[UoM Code].&[0/EmT],[Measures].[Employee Time])=0.0,NULL,([Units Of Measure].[UoM Code].&[0/Emt],[Measures].[Employee Time])/([Units Of Measure].[UoM Code].&[0/EmT],[Measures].[Employee Time Count])/365.25), FORMAT_STRING = "#,##0.0", VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Employees'; I have "unitsofmeasures" table and "UoM code" field inside it already. It's just that MDX I can't seem to translate.
Trouble Writing MDX Queries
Hi All, I'm having trouble understanding how to write a mdx query and I'm not sure how to write it to construct the below excel example. Could I please some help in achieving the below result? I'm using SAP BW Application Server as the data source. Desired Result: Example: (where basic finish date [20FINISHDATE] = 01.09.2022) Source I need to populate:Issue on MDX/DAX Cumulative by Day
Need help on MDX/DAX expert, I want to perform cumulative day by day, not sure why 7/14/2021 start onwards all cumulative data mess up. Expected Result on 7/14/2021 data should be 7030882 + 1080000 = 8,110,882 Formula: Cumulative Daily Progress = CALCULATE ( SUM ('Test Run'[Pass Count]), DATESMTD ('Test Run'[Updated Date]) )
Using filter in MDX
Hi all I want to filter an MDX query base on the sum of a integer field [Employee Wage Hours] at the year level, but displaying weekly summation results. Therefore I found how to filter taking into account the sum of [Employee Wage Hours] on a whole week (easy): SELECT NON EMPTY{ [Measures].[Employee Wage Hours] } ON COLUMNS, FILTER (([03-Employee Info].[Employee Name].[Employee Name], [02-Week Period].[Week No].[Week No], [02-Week Period].[Hierarchy].[Year] ), SUM([Measures].[Employee Wage Hours]) > 20 ) ON ROWS FROM ( [Model]) Then I have the employee/week/year for which there is more than 20 [Employee Wage Hours] a week, for each week. But I cannot see, since I have a "week" row, how to have the same 3-uples for which there is more than 20 [Employee Wage Hours] a year. Do I have to use a WITH clause ? Thanks for your answer...
