Hi Malori, Here is a formula that I use to calculate a running total YTD: YTDActual = Var MaxDate = MAX ( BIDates[Date] ) Return SUMX ( FILTER ( ALL ( BIDates ), AND ( ...
Hi Malori, Have you tried replacing MAX(d_MapCalendar[Date]) with TODAY()? ------------------------------ Arno Venter Senior BI Developer ------------------------------
Hi @Malori Meyer Can't you just use an IF statement? Example Running Total = VAR todaydate = Today() VAR runningTotal = CALCULATE( SUM(f_HedgeExecution[Amount Hedged]), FILTER( ALLSELECTED(d_MapCalendar[Date]), ...
Hello everyone, Please can someone share the details about the exam, like 1. How many questions will be there? 2. How much time do we get? 3. Is it online or do we have to go some place? 4. Do we get the result immediately or later? Or any other information ...
Hi Robert, Thank you for you help with hint on exam. I tried the link below. I was not by the group running the exam that practice exam questions are not available for 70-778 exam. Have you actually done the certified practice ...
Wonderful Richard. Thank you! ------Original Message------ Hi I passed the exam on Monday and I found the following practice test helpful. Unfortunately, I cant say more than that. https://www.youtube.com/watch?v=TOPtxY7kP-A&t=580s ...
Hi Elizabeth, The online documentation was enough for me plus working with the tool almost everyday. I've been doing self studying for decades and the fact I've taken so many exams helped as well. Please consider the other prep materials our friends ...
Did you know we offer a full schedule of training courses for these products? Year-round we hold Academy training classes either virtually, on-site, or both. We’re bringing in the experts to deliver the knowledge and skills you need to leverage these ...