I have a field name called Dr_Cr_Balance, which only has one value in the Chart of Accounts table. In the following expression I am testing to see if Hasonevalue = "debit" or "credit". If "debit, I want to multiple the TOTALYTD by 1, and if the value in the Chart of Accounts is "credit" then multiply it by -1. The expression works as long as there is a number in the MTD Actual column. If this is blank, then the YTD Actual has the wrong sign. Anyone have any ideas on how to fix this?
Can anyone help with the formula and the error message in my last message?
@pfernandez , It is better to have a measure like
calculate(1* [Amount $], filter(ChartofAccount, ChartofAccount[Dr_cr_flag]= "Dr") +
calculate(-1* [Amount $], filter(ChartofAccount, ChartofAccount[Dr_cr_flag]= "Cr"), Dateytd(Date[Date]) )
I do not think you all date , make sure date table is marked as date table and used in visual if needed
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
Hi Amitchandak, I tried this and I probably have a mistake somewhere in the formula. Can you take a look and help me fix this?
It looks like i was missing a comma in the second CALCULATE function. I added the comma and now I have this:
I am still looking for a solution. Does anyone know how to fix the above DAX statement?
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.