Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am a bit stuck here. I have a power bi report with 2 date tables (date from and date to). These have an inactive relation to my fact table. This allows me to easily calculate the variance:
Solved! Go to Solution.
@jvandyck , if want how to use these two tables you can refer this
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
On-trend , I am not clear, to have a trend you need to use a common table/column .
for that; Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
In the meantime, i also tried this post: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601.
It makes sense, but for some reason, I am not able to pass on the date selection to the variable in the calculated measure. Maybe someone can help me update the example PBIX I posted in my previous message?
@jvandyck , if want how to use these two tables you can refer this
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
On-trend , I am not clear, to have a trend you need to use a common table/column .
for that; Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Your post finally helped me out! I removed the inactive relationships:
And I played around with calculated measures:
Hi
Thanks for your help. On this link, you should be able to take a look at a mock-up I prepared. It contains the PBIX file as well as some fake data. You will see how I calculated the Variance. The issue is the trend chart...I want it to be controlled by the date from and to listbars....
Thanks again
Joos
forgot to paste the link: https://acerta-my.sharepoint.com/:u:/g/personal/joos_van_dyck_acerta_be/EfVVyRyKMSNCmzuroX66XlMBCWoY...
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |