Forum Discussion
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
- AnonymousNot 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- djmarcelobarrosNew 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- AnonymousNot applicable
djmarcelobarros,
I am not very clear about your requirement. Do you want to dynamically show different measures(current day, current year, current month,curent week) based on slicer selection? If so, please review the following blog.
http://visualbi.com/blogs/powerbi/dynamic-measure-selection-power-bi/
Regards,
Lydia