Forum Discussion

SES78's avatar
SES78
Regular Visitor
6 years ago
Solved

Date formula

I need to create a formula that will allow me to look at data from one date MINUS data from another date. i.e. what is the difference in $ between Sunday, December 2 and Monday, December 3.  I would...
Need Help
  • JasonTX's avatar
    JasonTX
    6 years ago

    Try something like this:

     

    DynamicSalesDifference = 
    var TodaySales = Calculate(Sum(FactInternetSales[SalesAmount]), DimDate[Date] =Today())
    var SundaySales = Calculate(Sum(FactInternetSales[SalesAmount]), WEEKNUM(DimDate[Date]) = WEEKNUM(Today()) && WEEKDAY(DimDate[Date]) = 1 && Year(DimDate[Date]) = YEAR(TODAY()))
    return TodaySales - SundaySales

     

    Replace all  FactInternetSales[SalesAmount] and DimDate[Date] with your own fields.

     

    Regards

JasonTX's avatar
JasonTX
Resolver I
6 years ago

Try something like this:

 

DynamicSalesDifference = 
var TodaySales = Calculate(Sum(FactInternetSales[SalesAmount]), DimDate[Date] =Today())
var SundaySales = Calculate(Sum(FactInternetSales[SalesAmount]), WEEKNUM(DimDate[Date]) = WEEKNUM(Today()) && WEEKDAY(DimDate[Date]) = 1 && Year(DimDate[Date]) = YEAR(TODAY()))
return TodaySales - SundaySales

 

Replace all  FactInternetSales[SalesAmount] and DimDate[Date] with your own fields.

 

Regards