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 All,
I have a daily stream of "market value" data. I can easily set up a report to display data as of the latest date or as of the latest month end date that is within the last 1 calendar months using relative date filtering.
However my unique need is to only show the latest month end date if the current day of the month is at least the 8th calendar day or later. If it isn't then the report should display as of the second latest month end.
For example:
My thought is to create a calculated column in my Dates table, with the logic of If today is greater than 7, monthend date is most recent from last month, otherwise monthend date is most recent from 2 months ago.
Any other easier ways to do it? Possibly without creating a calculated column?
Hi ChrisIsWorking,
So your requirement is to represent the lastest month end or second latest month end based off your logic, right? This logic can't be recognized by visual automatically so you have to create a calculate column or a measure instead. In your senario, if you just want to represent the date value in some visual, a measure may be more appropriate for you. If you want to change your data model, I would recommend that you cant still create a calculate column.
Regards,
Jimmy Tao
Hi Jimmy, thanks for the response.
In addition to having the date in a visual, I also need the additional data in a table visual for example to be as of the latest month end or second latest month end. So it's corresponding data to either month end.
I agree with having a calculated column. From your perspective, the calculated column should be in the Dates table yes? Or would it be in the table that contains the additional data that is being used in the table visuals?
Many thanks for your help!
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |