calculating sum of sales based on max date

[Anonymous]

Hi Experts

i am trying to work out the sales based on the max date as a measure and following is not working

Measure = 

VAR _lastdate = max(all(table[peroddate]))
Return

Calculate[charged days],Filter('table,'table[peroddate] = _lastdate))

getting erro message the MAX function only accepts a column as a reference in a n argument.

[VahidDM]

Hi @Anonymous 

Try this:

Measure = 

VAR _lastdate = Calculate(max(table[peroddate]),all(table))
Return

Calculate([charged days],Filter('table,'table[peroddate] = _lastdate))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

the issue is the date in the live connect in fact table is 1.11.21. where as the table in the power bi model has a max date or 1.10.21

[Anonymous]

Hi @Anonymous ,

In order to make troubleshooting and provide you a suitable solution, could you please share some raw data in your table with Text format , the formula of measure [charged days] and your expected result with calculation logic and special examples?

1. Raw data

2. The formula of measure [charged days]

charged days=calculate(count(xx),filter('table',xxx))

3. Expected result

Best Regards

[amitchandak]

@Anonymous , Try like

Measure =

VAR _lastdate = maxX(all(table) , table[peroddate]))
Return

Calculate[charged days],Filter('table,'table[peroddate] = _lastdate))

or

use

maxX(allselected(table) , table[peroddate]))

[Anonymous]

not working - sorry all, not getting the correct values for max date which is 01.10.21

[VahidDM]

Is [charged days] a measure? if yes, Can you share a code you used for [charged days]?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/