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.
I have a table like this
date | amount | week | Month | Quarter | Year |
2020-01-01 | 5 | 49 | 12 | 4 | 2020 |
2020-01-01 | 5 | 49 | 12 | 4 | 2020 |
2020-01-02 | 2 | 49 | 12 | 4 | 2020 |
2020-01-02 | 2 | 49 | 12 | 4 | 2020 |
2020-01-02 | 4 | 49 | 12 | 4 | 2020 |
2020-01-02 | 8 | 49 | 12 | 4 | 2020 |
2020-01-03 | 0 | 49 | 12 | 4 | 2020 |
2020-01-03 | 6 | 49 | 12 | 4 | 2020 |
2020-01-04 | 8 | 49 | 12 | 4 | 2020 |
2020-01-03 | 7 | 49 | 12 | 4 | 2020 |
2020-01-04 | 10 | 49 | 12 | 4 | 2020 |
2020-01-05 | 7 | 49 | 12 | 4 | 2020 |
2020-01-06 | 0 | 49 | 12 | 4 | 2020 |
2020-01-06 | 6 | 49 | 12 | 4 | 2020 |
2020-01-06 | 22 | 49 | 12 | 4 | 2020 |
2020-01-07 | 0 | 49 | 12 | 4 | 2020 |
2020-01-08 | 1 | 50 | 12 | 4 | 2020 |
2020-01-09 | 0 | 50 | 12 | 4 | 2020 |
2020-01-10 | 5 | 50 | 12 | 4 | 2020 |
2020-01-10 | 0 | 50 | 12 | 4 | 2020 |
2020-01-10 | 4 | 50 | 12 | 4 | 2020 |
2020-01-10 | 1 | 50 | 12 | 4 | 2020 |
2020-01-11 | 0 | 50 | 12 | 4 | 2020 |
2020-01-12 | 55 | 50 | 12 | 4 | 2020 |
2020-01-13 | 10 | 50 | 12 | 4 | 2020 |
2020-01-14 | 11 | 50 | 12 | 4 | 2020 |
2020-01-15 | 12 | 50 | 1 | 4 | 2020 |
2020-01-16 | 122 | 51 | 1 | 4 | 2020 |
2020-01-17 | 2 | 51 | 1 | 4 | 2020 |
2020-01-18 | 1 | 51 | 1 | 4 | 2020 |
2020-01-19 | 1 | 51 | 1 | 4 | 2020 |
2020-01-20 | 5 | 51 | 1 | 4 | 2020 |
2020-01-21 | 6 | 51 | 1 | 4 | 2020 |
2020-01-22 | 4 | 51 | 1 | 1 | 2020 |
2020-01-23 | 6 | 51 | 1 | 1 | 2020
|
I want to create a report like this base on this table
Date range | Total amount |
01-Jan | 10 |
WEEKQTY | 92 |
MonthQTY | 179 |
QuarterQTY | 328 |
YearQTY | 338 |
Solved! Go to Solution.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
I did it like the following, PBIX is attached.
Measure =
VAR __Item = MAX('Table2'[Column1])
VAR __Date = SELECTEDVALUE('Table'[date ])
RETURN
SWITCH(__Item,
"Day",SUMX(FILTER(ALL('Table'),[date ] = __Date),[amount]),
"Week",SUMX(FILTER(ALL('Table'),[week] = MAX([week])),[amount]),
"Month",SUMX(FILTER(ALL('Table'),[Month] = MAX([Month])),[amount]),
"Quarter",SUMX(FILTER(ALL('Table'),[Quarter] = MAX([Quarter])),[amount]),
"Year",SUMX(FILTER(ALL('Table'),[year] = MAX([year])),[amount]),
BLANK()
)
perfect
Awesome @Mniknejad , glad it worked!
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |