Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Calculation Help

Dear All,

 

 

I am making a property management report, where I am calculating what is *Revenue Recognition* to calculate that I have two date fields one *[Revenue Start Date]* & *[Revenue End Date]* now, i made date calender using min date and max date of start and end fields 

i have give two inActive relation now, how would i calculate the amount ???

Revnue Recognition Amt = calculate(sum(table[Amt]),userrelationship(table[Revenue Start Date], Dates[date])
OR

Revnue Recognition Amt = calculate(sum(table[Amt]),userrelationship(table[Revenue End Date], Dates[date])

 

which one is correct, how would i calculate the exact amount

 

I want to put this into a tabular form where property name and month name with exact amount

 

 

please help

2 Replies