topic Re: Create a column with condition based on different columns in DAX Commands and Tips

Create a column with condition based on different columns

surajbh — Tue, 12 Oct 2021 09:55:45 GMT

Hi all,
I want to create a formula in DAX, which create a case/ condition as column - status (New, updated,unchanged).
that should compare between today vs yesterday (latest date as of yesterday) and primary key, sales )

Let me know if the above question/query is still unclear.
Thank you very much for the support.

Greeting,

Re: Create a column with condition based on different columns

amitchandak — Tue, 12 Oct 2021 11:06:20 GMT

surajbh , Try a new column

new column =
var _last = maxx(filter(Table, [Date] =earlier([Date])-1 && [primary key] =earlier([primary key])),[sales])
return
Switch(true() ,
isblank(_last) , "New" ,
_last <> [sales] , "Updated"
,"same"
)

Re: Create a column with condition based on different columns

surajbh — Tue, 12 Oct 2021 11:49:18 GMT

amitchandak thank you for the code.
if in the above scenario, if I want to find the delta of sales with reference today(the one which I filter) and yesterday (with reference to filtered)- what could you suggest to write in dax.
thank you in advance.

Re: Create a column with condition based on different columns

v-yingjl — Fri, 15 Oct 2021 02:24:27 GMT

Hi surajbh ,

The reference could be like this:

Reference = VAR _last = MAXX ( FILTER ( 'Table', [Date] = EARLIER ( 'Table'[Date] ) - 1 && [Primary key] = EARLIER ( 'Table'[Primary key] ) ), [Sales] ) return [Sales] - _last

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Create a column with condition based on different columns

surajbh — Tue, 26 Oct 2021 05:10:16 GMT

v-yingjl thank you for the support.
if in the above-given scenario, the user has the possibility of filtering or choosing ( two dates- one to another date ), that will determine the status of the primary key.
How could you write DAX.
thank you in advance for the support.