topic Re: If condition on the next column in DAX Commands and Tips

If condition on the next column

Anonymous — Tue, 28 Jul 2020 09:20:18 GMT

Hello everyone , i need help with a calculate if condition ,so my dax formula is :

IF((table1[column3]+1)=0, 0, table1[column2] but it does'nt work because it display the the value on all projetctions , i want that stop displaying the column 2 on the second projection of column3 = 0 , like when " (column3 = 0)+1 only" stop there.

can you give some help please ?

Re: If condition on the next column

amitchandak — Tue, 28 Jul 2020 10:07:49 GMT

Anonymous , power bi do not concept for previous column next column for formula. So let us know what you need , based on that we need to create a formula

Like MOM

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date])) last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH))) last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH)))) diff = [MTD Sales]-[last MTD Sales] diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

check : https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

Appreciate your Kudos.

Re: If condition on the next column

Anonymous — Wed, 29 Jul 2020 15:00:21 GMT

Hello and thanks for your response, to be clear the column2 (a substraction by month)is a measure that I had already calculated it previously and i wanna just display the value when the column 3 (the rest of the substraction) turn to zero but the problem that I should keep the value of the column2 on the last month just to show that we have subtract this value (column2) so that is why the column 3 turns on zero so I thought that the formula that i did gonna to do the work but I'm wrong

Re: If condition on the next column

sturlaws — Tue, 04 Aug 2020 13:31:49 GMT

Hi Anonymous,

it is not at all clear what you are trying to do. Could you provide a sample report?(In order to share it upload it to e.g. dropbox/onedrive/other and share the link)

Cheers,
Sturla