topic Re: How to get current week, last week, current month, last month, last year for multiples metrics? in Developer

How to get current week, last week, current month, last month, last year for multiples metrics?

pranesh246 — Tue, 19 Jan 2021 11:39:00 GMT

I need to make a matrix column with multiple metrics as rows and current week, last week, current month, last month, last year as columns. How do i get it in power bi?

Re: How to get current week, last week, current month, last month, last year for multiples metrics?

lbendlin — Tue, 19 Jan 2021 18:40:32 GMT

If you do frequent data source refreshes (ie daily) then you can create calculated columns for these during the ETL. If you need measures (which I don't think you do) then use the same formulas but make sure to adjust the filter context accordingly.

Re: How to get current week, last week, current month, last month, last year for multiples metrics?

Anonymous — Thu, 21 Jan 2021 06:24:58 GMT

Hi @pranesh246,

According to your description, I think measure expression should suitable for your requirement. For your scenario, I think you can create a matrix with category and date hierarchy fields and write a measure with DAX expressions to extract current row contents and compare with 'if statement' or use switch functions to replace the displayed value with different expression results.

BTW, if you are confused about coding formulas, can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng