Forum Discussion
Calculate ranks dynamically based on Slicer
My data model consists of a single table (HANA view), where I connect to using DirectQuery. I don't have a date table but simply a date column with posting dates.
Skilled SharerAnonymous
You are trying to do a time intelligence here and in Power BI / Tabular echo system you will need a data table for that. Basically, you have two options. Bring your data in not as DirectQuery but as an import and then create a data table in M or keep DirectQuery but create a data table in your SAP source.
N -
Well, there's a challenge. DirectQuery is a requirement, but DirectQuery doesn't support relationships between HANA views. I basically need two measures:
1: total until the maximum date, while ignoring minimum date2: total until the minimum date, while ignoring anything above.
- nickchobotar
Anonymous
At this point it will be best if you share with us some data samples with the end result.
N -
Hi nickchobotar
Here's the sample .PBIX file: https://we.tl/bsdSlQ6G1P
Looking back at my question, there are two measures that I need to create. First of all my report has a minimum and maximum date in a slicer.1. A measure that sums all stock until the minimum slicer date
2. A measure that sums all stock until the maximum slicer date
as mentioned before, because I'm using DirectQuery on SAP HANA, the following actions are impossible:
- Create a date table;
- Create relationships between tables.
Thanks in advance