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 Days||Last 30 Days||Month to Date||Year to Date||Last Year|
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 :
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.
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?