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.
I have a scenario to work on where I have dashboard which contain:
1: SUM(Amount) for today (which will be realtime ) 2: SUM(Amount) last week same time (which will be data from DB using direct query) 3: a KPI which will check if the Today amount is greater or smaller and then calculate the percentage
I'm not sure if you are able to accomplish this. Let me elaborate:
Thanks nickyvv for the help.
The source of my real time data is EventHub.
For a moment if I ignore Slicer,as let me hard code it in worst scenario.
I am not sure if the below scenario is possible as I am not able to achive this.
I have 1 report with Directquery which bring Amount=y$(last onth same date)
Another report with Real time data where Amount=x$
I ping cards from Both card to dashboard.
Now I need to find% diff between both ..but not sure how to do it ?
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.