Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 date function with Calculate(Sum), but to no avail.
Eventually I'd like to specify quarters, but for now since I'm so new, I'd like to have the measure specify that any data created after a specific date, would be drawn into the graph when selected.
Thanks for any and all help!
LD
Solved! Go to Solution.
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!
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!
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 )
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |