Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Acquiring data from a specific start date

Hi all,   I'm new to PowerBI at my company and I'm trying to setup a measure that pulls data from one table, that was created at the beginning of the year.  I have tried a few iterations of the dat...
  • Anonymous's avatar
    Anonymous
    6 years ago

    I appreciate the suggestions,

     

    I completely overlooked the TotalYTD option, so I spent a lot of time on a simple solution.

     

    This should return all the data I need for now, but I'll keep the suggestions if I need to incorporate further information.

     

    Thanks so much!

AlexAlberga727's avatar
AlexAlberga727
Icon for Resolver II rankResolver II
6 years ago

Static date, or dynamic?

 

There is a DAX expression to gather the difference between dates if needed.

 

DATEDIFF(date1,date2,interval)

 

Example of how to write the difference between 2 dates using variables and the DATEDIFF DAX.

Difference Between Days = 

VAR Day1 = MIN( fSales[InvoiceDate] )
VAR Day2 = MAX( fSales[InvoiceDate] )

RETURN
DATEDIFF( Day1, Day2 , DAY )

 

AlexAlberga727's avatar
AlexAlberga727
Icon for Resolver II rankResolver II
6 years ago
Sales from XDATE to YDATE = 

VAR X = DATEADD( dDateTable[Date] , -90 , DAY )
VAR Y = TODAY()-1

RETURN

CALCULATE( [Total Revenue], DATESBETWEEN( dDateTable[Date], X , Y )