Forum Discussion

ajit_singh's avatar
ajit_singh
Frequent Visitor
5 years ago
Solved

Help request in creating a boolean measure using related table - pbix & dax query template provided

Dear DAX experts,   pbix file location:  https://github.com/business-data-analytics/powerbi/raw/main/assets/ajit-dax-modeling.pbix   "f2" table has many to one relationship with "time_date" table...
  • Fowmy's avatar
    Fowmy
    5 years ago

    ajit_singh 

    Make a small change to your formula: Replace RemoveFilters() with F2

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn
    CALCULATE ( MAX ( time_date[time_date] ), F2 )


ajit_singh's avatar
ajit_singh
Frequent Visitor
5 years ago

Sorry, by current date, I meant the date of the current row in time_date table.

 

f2 table contains the data for 2007, 2008 & 2009 year. So, the output of the query should have the value true only for dates of year 2007, 2008 & 2009 year and the rest of the dates should have the measure value as false.