Forum Discussion

mwolfc's avatar
mwolfc
Frequent Visitor
2 years ago
Solved

Convert a DAX measure

Hello, well, after 4 hours of research and Chat GPT, it's time to ask my Forum friends!   Question:  I have a DAX measure which I'm using in a card visual, which gives a count of records, and it wor...
Calculated Measures
Measures
  • some_bih's avatar
    some_bih
    2 years ago

    Hi mwolfc you already have rows, if your measure works as expected 🙂

    In your measure, filter part will give your "rows"

    Put this into calculated table and you will have it.

     

    FILTER(
    'Booked Sales',
    'Booked Sales'[QW Date] >= (TODAY() - WEEKDAY(TODAY(), 2) - 6) && 'Booked Sales'[QW Date] <= (TODAY() - WEEKDAY(TODAY(), 2))
    )

     

    Did I answer your question? Kudos appreciated / accept solution!

some_bih's avatar
some_bih
Community Champion
2 years ago

Hi mwolfc you already have rows, if your measure works as expected 🙂

In your measure, filter part will give your "rows"

Put this into calculated table and you will have it.

 

FILTER(
'Booked Sales',
'Booked Sales'[QW Date] >= (TODAY() - WEEKDAY(TODAY(), 2) - 6) && 'Booked Sales'[QW Date] <= (TODAY() - WEEKDAY(TODAY(), 2))
)

 

Did I answer your question? Kudos appreciated / accept solution!