Power BI issues with measures
Ngân sách $10-30 USD
- Freelancer
- Các công việc
- Power BI
- Power BI issues with measures
I'm having with a few of them and the date slicer,
Measures that work so far
MTD Sales = TOTALMTD ( SUM ( Orders[SubTotal_Shipping] ), 'Date'[Date])
SalesMTDLastYear = CALCULATE([MTD Sales],SAMEPERIODLASTYEAR('Date'[Date]))
Previous Month Total = CALCULATE ([Total Sales], DATEADD ( DATESMTD ( 'Date'[Date] ), -1, Month ))
Measures that don't work yet
Previous Month MTD Sales = TOTALMTD ( [Total Sales], DATESMTD ( 'Date'[Date] )) ----- This DOES NOT WORK PLEASE HELP
Charts I need help with the measures for
Line Chart - Day of Month Cumulative Sales Trends Prior vs. Current Month by Market
Line Chart - Prior Three Months Global Sales Trends by Market
Được trao cho:
Hi I have 11+ years of experience in Data Analysis, Data warehousing ,Business Intelligence . I have worked on following technology stack. Power BI, SQL Server , SSIS , SSAS , Excel, Azure Data Factory, Azure Data la Thêm
2 freelancer chào giá trung bình$33 cho công việc này
Hi, I have already worked on these type of situations, please consider providing this project. thank you