I want to show YearQty,MonthQty, QuarterQTY,WeekQTY in same reprt

[Mniknejad]

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

[Greg_Deckler]

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()
    )

[Mniknejad]

perfect 

[Greg_Deckler]

Awesome @Mniknejad , glad it worked!

[Greg_Deckler · Accepted 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...