Forum Discussion

User38690's avatar
User38690
Regular Visitor
2 years ago
Solved

Dax calculation using two different date columns

Hello,  I have two different dates, the first shows how many orders I received and the second shows how many I fulfilled.   I want to make one table that shows how many orders I received in ...
  • mangaus1111's avatar
    2 years ago

    Hi User38690 ,

    you have to use a date table with one active relationship to Column "Month_1" and one inactive relationship to Column "Month_2"

     

    Please see my pbi file Dax calculation using two different date columns.pbix

     

    Best Regards
    mangaus1111

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly