Kindly delete. Thanks!

Question

idrissshatila · Answer

Hello,&nbsp;You make a new table and ente the dax function calendarauto() and it will automatically gives you all the dates from your min data date till the max and you connect them together in the data modeling section and now you can use it to filter them.&nbsp;you can know more about calendarauto from this link https://learn.microsoft.com/en-us/dax/calendarauto-function-dax&nbsp;If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudo 👍Follow me on Linkedin

lancersc · Answer

The problem is, when I inner join Table1 and Table2 the year and month will be irrelevant on Table 3&nbsp;For exampleTable1InvoiceYear&nbsp; &nbsp; &nbsp;InvoiceMonth&nbsp; &nbsp; &nbsp;BranchCode&nbsp; &nbsp; &nbsp;ItemID&nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01673&nbsp; &nbsp; &nbsp; &nbsp; 2053249&nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01661&nbsp; &nbsp; &nbsp; &nbsp; 0300000&nbsp;Table2InvoiceYear&nbsp; &nbsp; &nbsp;InvoiceMonth&nbsp; &nbsp; &nbsp;BranchCode&nbsp; &nbsp; &nbsp;ItemID&nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01673&nbsp; &nbsp; &nbsp; &nbsp; 2053249&nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01661 &nbsp; &nbsp; &nbsp; 0300000&nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01673&nbsp; &nbsp; &nbsp; &nbsp; 2700000Table3 (Inner Join Branch Code and ItemID)BranchCode&nbsp; &nbsp; &nbsp;ItemID01673&nbsp; &nbsp; &nbsp; &nbsp; 205324901661 &nbsp; &nbsp; &nbsp; 0300000When I filter Table1 and Table2(which is in a relationship in Month) for example Month 2, I want the table 3 to only show Month 2ExampleTable3 (Inner Join Branch Code and ItemID)BranchCode&nbsp; &nbsp; &nbsp;ItemID&nbsp; &nbsp;01673&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2053249&nbsp;

Forum Discussion

Kindly delete. Thanks!

2 Replies

Related content

Can't delete Fabric items no Delete option available

Can't Delete Item

Can't delete measure

Incremental Refresh deletion

Workspace deletion