Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
i am facing some error, let me know if anyone can help, below is the error and my table
Solved! Go to Solution.
Hi @vjnvinod
Create a column like
column = IF([event_date]=BLANK(),"upcoming", IF([event_date]<DATE(YEAR(today()),MONTH(today()),1),"YTD", FORMAT([event_date],"mmm-yyy")))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @vjnvinod
What is the "current month","previous month"?
For example, when event date=2018/11/15, is this date equal to "previous month" or not?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Current month is basically June 2019 and anything prior to June 2019 is previous month
Hi @vjnvinod
Create a column like
column = IF([event_date]=BLANK(),"upcoming", IF([event_date]<DATE(YEAR(today()),MONTH(today()),1),"YTD", FORMAT([event_date],"mmm-yyy")))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |