Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Good afternoon, I would appreciate it very much if you can help me
The case is as follows:
I have two tables with data
The first table is:
from where we will take the categories for the matrix.
The second table is:
From this we will take those that are from July 1 and 2, 2022.
What I am looking for is to be able to make the following matrix:
What I need is for July 2, 2022 to add the value of the previous day plus the value of July 2.
Please note that from table 2 there is data from other dates which I do not want to bring to the matrix and that I would prefer to do it within the DAX formula and not with external filters.
One more doubt: if you wanted to bring the accumulated of the previous month, that is, the figure of 30/06/2022, it can be done and how it would be done???.
I thank you for the yuda.
Hi @Syndicate_Admin ,
You can do something like
cumulative sum =
CALCULATE (
SUM ( table[value] ),
FILTER (
ALL ( table[date] ),
table[date] <= MAX ( table[date] )
) //to create a sum of values where date is less than or equal to the date in the current filter context
)
Proud to be a Super User!
Thank you very much, I already tried the formula, but it does NOT work, for some reason I accumulate the figures since 2020 by category but does not filter me those of the month.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.