Forum Discussion
Entry with Max Date
Community ChampionHi Anonymous it seems you need standard star schema model in Power BI. Service seems like sales in Contoso model for Power BI.
For last sales / service date according to this model on dax.do you can use something like below (simple max date of sales) with few columns
https://dax.do/NsCjd1Sto0Lh0W/
Check link for example of diagram on dax.do
On the link below https://dax.do/diagram/
Hope this help, kudos appreciated.
Apologies for the slow reply. While this does help if my output is a row-level table, what I intend to do is create a visualization. For instance, if I wanted to show a breakdown at the race/ethnicity level, the challenge is that the measure above selects the latest date as of the whole dataset. I have tried many variations of this using ALLEXCEPT, for instance, and I need the output to select the latest date as of a date slicer PER PERSON and then identify the relevant race/ethnicity for my visualization.
- some_bih
Hi Anonymous please share soome sample data of your inputs and expected output.
Yes, in example above max, last date is for overall data. So we need your details.