The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hey all, Im trying to create a Running Total (RT) function for Actuals, Budget and Forecast data. I have included the following function:
Any suggestions to why this maybe the case? TIA!
Solved! Go to Solution.
@MFelix this worked for me:
Thanks @MFelix @JW_van_Holst for your responses. Ive had a slightly different issue. My pc required a restart to install updates and I didnt save the file. To recover the file, I reopened the file from Autorecovery in PowerBI and when I did Im stuck with this page. Any idea how this can be recovered to its previous state?
Hi @alijalil ,
If the recovery file is also "broken" you don't have any way to get the recovered file. Try tomcheck the folder where the file is saved.
The folder is on the options of the PBI. but be aware that this are temp files and since you open it it may be already deleted.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @alijalil ,
Believe you have the syntax of the ISONORAFTER incorrect try the folllwing:
Actual RT =
CALCULATE (
SUM ( Actuals[Actual] ),
FILTER (
ALLSELECTED ( 'calendar'[Date] ),
ISONORAFTER ( MAX ( 'calendar'[Date] ), desc )
)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix this worked for me:
ISONORAFTER is a utility function. Do not use it in measures.
Try:
RT =
VAR LastVisibleDate =
MAX ( 'calendar'[Date] )
VAR PeriodToUse =
FILTER ( ALL ( 'calendar'[Date] ), 'calendar'[Date] <= LastVisibleDate )
RETURN
CALCULATE ( SUM ( Actuals[Actual] ), PeriodToUse )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |