CODEWITHSUNDEEP
ssasbusiness-intelligencetabulardaxmsbi
Jay Doshi
Jay Doshi

Reputation: 340

How to calculate Actual Sales per day using DAX

I'm trying to get Actual Sales per day using DAX howver I can't able to get the Actual Sales Per Day using DAX Expression.

enter image description here

I'm using below DAX to calculate Total No. of days.

b:=CALCULATE(COUNT(DimDate[Date]),DimDate[CY_Year]=YEAR(TODAY()),USERELATIONSHIP(Fact_Sales[Doc_Date],DimDate[Date]))

Please provide the correct formula.

Upvotes: 0

Views: 1243

Answers (1)

Rory
Rory

Reputation: 969

Assuming [a] is a measure in the Data Model then you just create a new measure for Actual Sales Per Day as follows:

c :=
[a] / [b]

If [a] is not already a measure in the Data Model then create it first as follows:

a :=
SUM ( [SalesAmount] )

Upvotes: 0

Related Questions