Forum Discussion
Last Modified Date vs all Customers with the same Last Modified Date
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