Forum Discussion
DAX
Reading over your whole post i'm thinking this should be done in Power Query instead of dax. Never the less, here is the dax for Q1
Q1: Create a Custom Column:
Status = var thisRecord = [ID] RETURN CALCULATE( COUNTROWS('Table2'), ALL('Table2'), 'Table2'[ID] = thisRecord ) > 0Q2: I really really stress this is going to be a bad idea. The 'Edit Queries' are of Power BI is much better suited to creating tables. Q1 could also be achieved there as well.
Is there a specific reason you want to do this with Dax?
In the Edit Queries section, if you right click on any query (a table), there is an option called "Reference".
This creates a new table that begins as a reference to that other table. From here you can remove rows, add new columns and do all of the general import manipulate you like. When you click close and apply, you will see it as its own table, named however you wished.
Thank You for your reply.The DAX is working fine.How to compare the a substring value of table2[ID] ?
I think the answer in this thread might be along the lines of what you are looking for:
Thank you.How can i get current date and first working day of a month in DAX?
the formula TODAY() will give you todays date.
If you want the first working day in the month, you will need create a Date Table and create a column in that date table that tracks day of the week. From there, you should be able to use something that contains the date table to the month you care about (either via a Calcualte Statement or from a slicer) and then you need to use FIRSTDATE inside a calculate statement that constrains on only the weekdays you care about.