Forum Discussion

macwhe's avatar
macwhe
Helper I
4 years ago
Solved

max per order issue

Hi All,   I am struglling with MAX function. I have 2 dimension tables and on Facttable. between 2 dimensions there is a inactive relationship . and between the fact table and FreezeDate Snapshot t...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    4 years ago

    Hi macwhe,

     

    Try measure as:

    Measure = 
IF(
    MAX(Facttable[FreezeDate])>=ALLSELECTED('Second Dimension'[Freeze Comparison Snaphot]) && MAX(Facttable[FreezeDate])<=ALLSELECTED('First Dimension'[Freeze date SnapShot]),
    1,
    0
)

    Here is the output:

    The demo is attached, please try it.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

lbendlin's avatar
lbendlin
Super User
4 years ago

Are these snapshot dates predefined or would it be easier to let the user select the date range via a slicer?

macwhe's avatar
macwhe
Helper I
4 years ago

HI, the dates are selected by user  Below are the dates that I have available in the slicers. Basically  we have a new freeze date everyday depending on the business and at end of the month we also have a freeze. I forgot to mention I am using Direct Query. thanks a lot slicers

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    My question was if you could combine both slicers into one date range slicer.

    • macwhe's avatar
      macwhe
      Helper I
      4 years ago

       I cannot combine both slicers the date range , I need to have 2 slicers.

      Thanks