Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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?            
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

Create a measure using dax below:

Result = CALCULATE(MAX('Table'[Net]), FILTER('Table', 'Table'[Date] = DATEVALUE("31/12/2017")))

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Hi ,
 
Thank you for your reply. The solution works if I want to calculate Total GST for financial  year ended to 31/12/2018 as GST net balance at 31/12/2017 is required to calculate total GST recieved in 2018. However if I want to dasame for financial year ended to 31/12/2017 i will need to have GST net amount as at 31/12/2016. In other words DATEVALUE must be dynamic. Could you please help me to acieve this.
 
regards
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    I am not clear with your question.  Please show the exact result you are expecting.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.