Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Compare dates not working

Hi there,   my aim is to compare two dates within an if clause. Naturally, the formula should show all values, if their date is larger than my selected date (03.08.2020). But I don't know why the...
Date
Date measures to filter data.
  • Anonymous's avatar
    Anonymous
    6 years ago

    Solved the problem myself.

    The problem was that several dates had to be evaluated while only one was expected. I changed the "Dates" part with a new column which only shows the first date of each week for each date.

     

    Ø Annual Turnover (EUR) Done = 
IF(
   MAX('NPLM Import'[Plan R@R (internal) Date]) >= SELECTEDVALUE('Dates(2)'[StartofWeek]), 
      IFERROR(SUM('NPLM Import'[Yearly average turnover (EUR)]), "")
)

     

     

    Btw: There is nothing wrong with my dataset and connections are still maintained as before. My original post (https://community.powerbi.com/t5/DAX-Commands-and-Tips/Compare-dates/m-p/1268717) which was marked as spam, disappeared and suddenly returned, did help me solve the issue instead of instructing me.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Solved the problem myself.

The problem was that several dates had to be evaluated while only one was expected. I changed the "Dates" part with a new column which only shows the first date of each week for each date.

 

Ø Annual Turnover (EUR) Done = 
IF(
   MAX('NPLM Import'[Plan R@R (internal) Date]) >= SELECTEDVALUE('Dates(2)'[StartofWeek]), 
      IFERROR(SUM('NPLM Import'[Yearly average turnover (EUR)]), "")
)

 

 

Btw: There is nothing wrong with my dataset and connections are still maintained as before. My original post (https://community.powerbi.com/t5/DAX-Commands-and-Tips/Compare-dates/m-p/1268717) which was marked as spam, disappeared and suddenly returned, did help me solve the issue instead of instructing me.