Creating Table / Matrix with Measures in Rows and different time periods in columns

Anonymous,

You can do that in Power BI. You will have to create a measure for each expected outputs:

Last n days =
CALCULATE (
    SUM ( Table[val] ),
    FILTER (
        ALL ( Table ),
        Table[date]
            >= MAX ( Table[date] ) - n
            && Table[date] <= MAX ( Table[date] )
    )
)

Then, check MTD and YTD function, many examples can be found on the forum.

Same for LY using SAMEPERIODLASTYEAR function.

Please aslo check microsoft documentation which provide examples :

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Cheers

Anonymous,

This can be achieved by using DAX function like time intelligence function. You can refer to: https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax.

https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your help. I am familiar with DAX and the time intelligence function. 

Unfortunately, your reply does not answer my question. I think the tricky part is to have different custom measures with different timeframes as columns, right?

Anyone an idea?