Forum Discussion
Snapshot data in Power BI
Hi All, I have a question about modelling data using Power BI. In my industry we frequently report on the number of clients open to a staff member, team or service on any given day - e.g. the...
Hi Anonymous,
Sorry, I was being an idiot - I was creating a calculated column, not measure! Oops...
When you have a moment, I'm still interested though - what relationship(s) did you define between DIM_DATE and FACT_PLANS? I ask because I current use DIM_DATE(date) and FACT_PLANS(Plan Start Date) and it doesn't quite return the correct values.
Thanks again :)
Pbix
Hi Anonymous,
I just copy your sample data and enter it to Power BI Desktop, no relationship is created between the tables. What is the relationship between your tables? And what does your measure look like?
Thanks,
Lydia Zhang