show previous all quarters data including with currently selected quarter

[Anonymous]

Hi All,

how to show previous all quarters data including with currently selected quarter?

Thanks,

Muni

[amitchandak]

Do you have a date. Then you can have date calendar and try the following. Move your Qtr to date dimension

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[Anonymous]

Hi Amitchandak,

Thanks for your time.

could you pleease tell me what is the "date" (filter (date,date[date])) field in the below DAX

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))

Thanks,

Muni.

[amitchandak · Accepted solution]

Date is my date table date date there is joined with my sales fact.

Better example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[Date] <=maxx('Date','Date'[Date])))