Forum Discussion
Retrieving a value
I am pretty bigginer in DAX and trying to write a formula to find Net as at 31/12/2017 in below table which is -313978.32. Could you please help me?
Hi,
Sorry If I could not explain it well. I am trying to build a cash flow report. The report will have Year and Months slices and the users can select the year and the month for which they want to prepare cash flow report. One of the items which will be shown on the report is Net GST. it is calculated as the difference between Net GST amount at the end of selected month and at the end of last financial year.
For example if the user selects Year 2018 and month February, the Net GST shown on the report will be calculated as the difference between Net GST at 28/2/2018 and Net GST at 31/12/2017. Hope this explains the issue.
Regards
Gus
Hi Ashish,
It works perfectly. Thank you ver much.
Much appreciated.
Gus
You are welcome.