Dax Function

Question

Hi Experts,&nbsp;I have a query in the column 'balance due' and dates,2-3 years of data is there. So in power Bi I want to have running total with the current date, so when I refresh next month it automatically takes next month's date and refresh.&nbsp;Eg : 2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; January&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;152019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; January&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XYZ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15

wdx223_daniel · Answer

it's hard to achieve when there are duplicate values in the 3rd column.

Forum Discussion

Dax Function

1 Reply

Related content

DAX Studio space after function name

DAX function

DAX Info Functions Against Published Datasets

DAX product function

RANK and RANKX DAX function