Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculated column based on filters.

I want to create the following measure:   Hires = count of those employees whose transaon date = date[first date]). When I manually enter the first date, the value comes up.   The Manual par...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous try adding the first date calculation in the hires table. 

 

Is the transaction date hooked to the date table? 

what is the calculation for the first date?

Is first date driven by a filter?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey, how do I post the Power BI File?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Post it to dropbox or google drive and send a link here.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous Here are somethings I found. If you plug transaction date, date and first date in one table you will realize that first date dynamically changes based on what you prop in to 1 day prior to dec 31, 2016. 

         

        To fix this I removed -1 from first date formula 

         

        Also

        1) first date & Last date need to be calculated columns. 

        2) I created a new related column in sheet1 related(date[first date])

         

        Also all the dates need to be in same format either datetime or date.