Forum Discussion

armeizal's avatar
armeizal
Regular Visitor
6 years ago
Solved

Create new calculated table with multiple calculated column from 2 different tables with DAX

Hello, I am new to this. I need help to add new calculated table with multiple calculated column with DAX.   I have 2 table as below:   Table A:   Date A List A 1/07/2020 Content A1 ...
multiple column
new calculated column
new calculated table
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi armeizal ,

 

 


Make sure you have a date calendar and it has been marked as the date in model view.
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/

 

Create 2 measurse

 

COUNTTableA = COUNT('TableA'[ListA])

 

CountTableB = COUNT('TableB[ListB])

 

 

 

 

 

Regards,

Harsh Nathani

 

  • armeizal's avatar
    armeizal
    Regular Visitor
    6 years ago

    Hello Anonymous 

    It works for me, but there are blank space between 24-Jul to 30-Jul, but it wouldn't be a problem for my needs when I use this table to line chart.

     

    Thank you.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi armeizal ,

       

      Thanks . If this works kindly mark this as a Solution so that it helps other community members.

       

      Cheers,

      Harsh Nathani