Great work! I've developed financial reports using this approach and it's working fine, also you can add more than 0 (running total),1 (default) for other custom calculations incorporated in the final measure. I would suggest for running total using also like this: Running Total = CALCULATE( [Total Actuals], FILTER( ALL('DimDates'[Date]), 'DimDates'[Date]
Hi, for the calculate function at 1:00:39, I tried this exact formula and it did not work. Could you maybe explain some possible problems or DAX alternatives to Calculate that can give a filtered table. Thanks!
Could you please provide the link to the dataset? The link mentioned in the video is not working. I would greatly appreciate it if you could share the correct dataset link. Thank you!
Great work! I've developed financial reports using this approach and it's working fine, also you can add more than 0 (running total),1 (default) for other custom calculations incorporated in the final measure.
I would suggest for running total using also like this:
Running Total =
CALCULATE(
[Total Actuals],
FILTER(
ALL('DimDates'[Date]),
'DimDates'[Date]
Hi, for the calculate function at 1:00:39, I tried this exact formula and it did not work. Could you maybe explain some possible problems or DAX alternatives to Calculate that can give a filtered table. Thanks!
Thank you! Very helpful!
Could you please provide the link to the dataset? The link mentioned in the video is not working. I would greatly appreciate it if you could share the correct dataset link.
Thank you!
What does the column sub header detail do and what does 0 and 1 do? How does it relate to the headers table as well?
hello, thx for this video! The link to dataset doesn't open.
Hi ..thanks for making this video..its very helpful..Quick question would it still work in the same way when bring in GL accounts in the matrix?
great work. please i need help with similar work. i am stuck trying to create the data model any oneone who can help?
It seems you loaded your data twice as all values are doubled
nothing clear at all