topic Re: Yearly / Monthly / Weekly cumulative for all measures in the model in DAX Commands and Tips

Yearly / Monthly / Weekly cumulative for all measures in the model

Anonymous — Mon, 15 Feb 2021 10:38:40 GMT

Hey,

I would love to know if possible and how i am select one date in one table to filter another table time between two date

for example : i select 15/2/2021 in one calender table and in another table(linked to data model) select time between 1/2/2021 - 15/2/2021.

Using this I can put metrics in the sample model: sales, buying, discount, etc.

and they will be calculated according to the selected dates

i would love to do this at At the yearly / monthly / weekly level

This calendar I use in my model

Re: Yearly / Monthly / Weekly cumulative for all measures in the model

Anonymous — Mon, 15 Feb 2021 10:41:38 GMT

TransactionDate
DayNumberInWeek
DayShortName
WeekNumber
WeekStartDate
WeekEndDate
MonthNumber
MonthStartDate
MonthEndDate
QuarterNumber
CalendarYear
TransactionDateLY

Re: Yearly / Monthly / Weekly cumulative for all measures in the model

amitchandak — Mon, 15 Feb 2021 10:56:48 GMT

Anonymous , Not very clear. Create a date table and use time intelligence

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9

Re: Yearly / Monthly / Weekly cumulative for all measures in the model

Anonymous — Mon, 15 Feb 2021 11:01:16 GMT

Hey

thanks for your answers

i need something for all the measures

i will not would to create for all the measures in my model MTD/YTD

Re: Yearly / Monthly / Weekly cumulative for all measures in the model

amitchandak — Mon, 15 Feb 2021 12:47:59 GMT

Anonymous , For this case this table you are selecting date should be independent

"i select 15/2/2021 in one calender table and in another table(linked to data model) select time between 1/2/2021 - 15/2/2021"

example

MTD =
var _max = maxx(allselected([IDate]), 'IDate'[Date])
var _min = date(year(_max),month(_max),1)
return
calculate(sum('Table'[value]), filter('Table', 'Table'[Date] >= _min && 'Table'[Date] <=_max))

MTD is a better option