I admit, I am just starting out with DAX Statements. What I found out was that the MSFT Call Quality Data Warehouse will CLIP DAX request at 10K rows, . So I am trying to use the DAX Studio “Multiple EVAULATE” feature to get 500K or so records to a CSV file.

I have 3 measures to calculate active merchants in a given periods using DAX time intelligence. In addition to that, I need to also check that their first transaction (in FactTransaction) is in current relative year

I have a code below and each May is a new fiscal year.
Lets assume: we are in FY25 June ->I need to filter the table below for FY25 May.
: if we were in FY25 May ->I need to filter the table below for FY24 April.
How can i get around with this ? many thanks in advance.

I want to filter historical data on different tables.

I’m using trying to create a measure in DAX that measures the the activity of investigator’s in our company working in specific geographical areas and filter it by a range of dates Here is the code I’ve written:

I’ve got the following DAX measure

I’m trying to calculate a rank for a table and use the rank to calculate a running total in DAX Studio.