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