Forum Discussion

djmarcelobarros's avatar
djmarcelobarros
New Member
8 years ago

TREATMENT OF DATES (DAY, WEEK, MONTH, YEAR)

Good morning people,

 

I have a precise situation to do a data filtering, it is possible to choose between day, week, month and year. I was able to from the DAX function "Date.IsInCurrentWeek" parameterize a current week, through the IF below where "LAN_DATA" is its database table date parameter: if Date.IsInCurrentWeek ([LAN_DATA]) = true then "" something else "One Current data, MON and year.

 

What Happens During the First Day of the Current Week. I Believe To Be Anywhere Possible Now For Everyone, If Possible

.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    djmarcelobarros,

    This is English forum, please post question in English. In your scenario, please also share dummy data of your original table and post expected result.

    Regards,
    Lydia

    • djmarcelobarros's avatar
      djmarcelobarros
      New Member
      Good morning people,
      
      I have a precise situation to do a data filtering, it is possible to choose between day, week, month and year.
      
      I was able to from the DAX function "Date.IsInCurrentWeek" parameterize a current week, through the IF below where "LAN_DATA" is its database table date parameter:
      if Date.IsInCurrentWeek ([LAN_DATA]) = true then "" something else "One
      
      Current data, MON and year. What Happens During the First Day of the Current Week.
      
      I Believe To Be Anywhere Possible Now For Everyone, If Possible