Forum Discussion
What's the DAX syntax equivalent to a sql windowing
Community ChampionHi franck_axires ,
A quick data table placed in a Table visualization. Then use filters date is on or before, and Status Code for what is needed.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Nathaniel_C
Thanks for your reply.
I also need to create a measure that will be used to calculate ratios.
That's why I need the DAX formula...
If you have any clues...
Thanks again !
- Nathaniel_C
Hi franck_axires ,
You need a measure to help calculate ratios, but what you are showing us is a table. What two numbers do you need for the ratio?
We can do tables in the power query editor, or in the Power BI, but what a measure is doing is filtering the rows and returning a value that can go into 1 cell. Like the sum of a column.
So looking for more info here. Thanks!
==============Get status code = CALCULATE(max(Positions[StatusCode]),Positions[PositionDate]=DATE(2018,5,21)) We can do with parameter.And there is DATESBETWEEN() which we can probably use.
Nathaniel- Nathaniel_C
Hi franck_axires ,
So rereading everything, you said, you need to find the container ids for a specific Status Code between the beginning date, and the input date. You will be basing the Status Code on the input date, right? Will the parameter be chosen from a list of dates? Or will any date do with the next or previous date being used. We can do that with concatenex and give you a string of those ids separated with a delimiter, or we can give you a count of those ids.
Let me know!
Nathaniel
