Forum Discussion
Daily total between two dates
hi Anonymous
For your case, you could use a matrix visual to get it.
Just drag date field into columns of matrix visual, and for slicer, if you just want to choose two date, you'd better use list for this slicer.
and if you want use range of a slicer(Between), you could create a measure as below to get it:
Measure = var ascdaterank =RANKX(ALLSELECTED('Table'[Date]),CALCULATE(MAX('Table'[Date])),,ASC) var descdaterank =RANKX(ALLSELECTED('Table'[Date]),CALCULATE(MAX('Table'[Date])),,DESC) return IF(ascdaterank=1||descdaterank=1,CALCULATE(SUM('Table'[Cost])))Result:
and here is sample pbix file, please try it.
Regards,
Lin
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Thank you for the advice; I have tried to match your request and please let me know additional requests.
1. Power BI Usage_Details Table
Subscription_Name Cost Year Month Day Name_1 2.24643651 2020 May 1 Name_2 32.3810413 2020 May 1 Name_3 20.0792305 2020 May 1 Name_4 4.84115459 2020 May 1 2. Desired Result
SubscriptionName Cost Year Month Day Cost_2 Year_2 Month_2 Day_2 Name_1 2.246436511 2020 May 1 2.24643651 2020 May 17 Name_2 32.23771044 2020 May 1 32.3810413 2020 May 17 Name_3 20.09001796 2020 May 1 20.0792305 2020 May 17 Name_4 4.881155111 2020 May 1 4.84115459 2020 May 17 3. I would like the flexibility of selecting any two dates. I do not want, for example, to select the first date and then a relative second date (i.e., 1 week before, 1 week after).