Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
undergreat
Frequent Visitor

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

I am moving from Tableau to powerBI and i am looking to recreate reate the following visual / matrix / table. But I am struggeling. In general, is a structure like this possible in a PowerBI report? Thanks for your help!

 

 Last 7 DaysLast 30 DaysMonth to DateYear to DateLast Year
Impressions     
Clicks     
Conversions     
3 REPLIES 3
undergreat
Frequent Visitor

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?

v-yuta-msft
Community Support
Community Support

@undergreat,

 

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.

Arnault_
Resolver III
Resolver III

@undergreat,

 

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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.