Forum Discussion

Kostas's avatar
Kostas
Helper IV
6 years ago

Calculation into the Published report

Hello All,  I want to ask if I can stop the calculations of the PowerBi into the published report (via link to my organisation) I have in the organisation a specific report that I am publishing onc...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Instead of Today. Use max(Table[date]) in your formula. 

Example

Formula = 
Var   _start_date=(minx('Date',STARTOFYEAR('Date'[Date]))) 
Var   _end_date=(max('Date'[Date]))

Var _last_year_mtd_val= CALCULATE(sum(Sales[Sales Amount]),Sales[Sales Date] >= _start_date && (Sales[Sales Date]) <= _end_date,filter(Sales,COUNTROWS(SAMEPERIODLASTYEAR(Sales[Sales Date]))>0))
return
_last_year_mtd_val
Kostas's avatar
Kostas
Helper IV
6 years ago

Hello, 

Most of the formulas that I have are caculated within the table with DAX syntax. 

How can I transfer the code below in there?

 

Thanks