Forum Discussion
Last Modified Date vs all Customers with the same Last Modified Date
Hi Kornholio
What you could do is that you could find out what the last date is in your dataset, and then possibly use a Date table (which is recommended for Time Intelligence calculations) and based on the last date, you could then create a conditional column which would then have the value of "Last Date" next to this date.
Then in your report you could then use a filter or Chiclet based on this column and have it selected.
You would have to ensure that your data is being updated either manually or via the On-Premise Gateway to ensure that it is reflecting the latest date.
Also you mention Customer, do you have multiple Customers accessing the data?
And if so are you then using Row Level Security?
My plan is to complete the dashboard and when a users logs into it, they onl see their data. It comes from an Azure database, SQL. So, I am not sure how to set that p just yet, but yes they would log on, see there data compared to others in the system, basic comparisons.
Then when they log in, their most recent data they have entered into the Azure based database, will reflect similar customers that have entered within the same year.
Example, ABC Co. logs into the dashboard, they see relevant data to them compared to other businesess like theirs. But the data has to be within the same year the entered thier data. ABC Co. will see thier data compared to those that have entered data in 2017, 2016, etc.
Also, you mentioned a date table, is that like what this site shows?
Hi also I was looking up coditional column here,
https://exceleratorbi.com.au/conditional-columns-power-bi-desktop/
But I do not have that option in Power BI Pro, just add column
Alos the data is being entered manually by the customer each year into the Azure database.
