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.
hello all - i have a table that shows customer order information - Order Id, Customer Id, Order Date, Status, Amount. If i select a time period - month, quarter, etc. i need to show the the last period Amount. For example, if i select 2019 March, i want to show the Order Amount where the order date = March 1st 2019. Any ideas?
Hi @Anonymous,
You can calculate the First day of the month using below DAX formula:
Hi,
I assume you are wanting to do a Date Filter. There are multiple Types in this, You could use a Drop down Date Filter or a Slicer to Specify the Date Range ( Start and End Date).
1. Single Date Value
Value := VAR Date= SELECTEDVALUE(Order[date]) RETURN CALCULATE(SUM(Order[Order], Order[date]= Date)
2. Date Range (Slicer)
Value:= VAR First_Date= FIRSTDATE(Order[date]) VAR Last_Date=LASTDATE(Order[date]) RETURN CALCULATE(SUM(Order[Orders]), FILTER(Order, Order[Date] >= First_Date && Order[Date]<= Last_Date))
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
@Anonymous wrote:Hi,
I assume you are wanting to do a Date Filter. There are multiple Types in this, You could use a Drop down Date Filter or a Slicer to Specify the Date Range ( Start and End Date).
1. Single Date Value
Value := VAR Date= SELECTEDVALUE(Order[date]) RETURN CALCULATE(SUM(Order[Order], Order[date]= Date)2. Date Range (Slicer)
Value:= VAR First_Date= FIRSTDATE(Order[date]) VAR Last_Date=LASTDATE(Order[date]) RETURN CALCULATE(SUM(Order[Orders]), FILTER(Order, Order[Date] >= First_Date && Order[Date]<= Last_Date))
I just did a test but it is returning the same value as the Amount. See below. For example, for customer 456, date 4/1/2019, the Value measure should be 50. Thoughts?
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |