Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sudha1980
New Member

Sales Analysis Report

‎01-31-2019 08:18 AM

HI All

I need help to develop sales report with figures comparision Actual sales / previous sales and Target.

Thanks and regards
Sudharsan

Labels:
Message 1 of 2
295 Views
0
1 REPLY 1
v-jiascu-msft
Employee
Employee

‎01-31-2019 09:28 PM

Hi Sudharsan,

 

Can you share a dummy sample and the details of your requirements? You can try these time intelligence functions like dax/previousmonth-function-dax.

 

Actual Sales = sum('sales'[amount])
Previous Sales =
CALCULATE ( SUM ( 'sales'[amount] ), PREVIOUSMONTH ( 'calenar'[date] ) )

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 2
286 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All