Forum Discussion

eddd83's avatar
eddd83
Resolver I
7 years ago
Solved

count rows by month without creating relationship

In my table: X-High, High, Medium and Low are all measures. Total is just a measure summing the previous 4 measures. All-running total is the running total for the first 4 measures. X-high + hig...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    7 years ago

    I believe you can create a virtual relationship bewteen tables using the TREATAS function (never used it myself; so far have managed with inactive relationships and USERELATIONSHIP). Sorry I can't be of further help, but might be worth scouting the internet.

     

    Try here for example: TREATAS by enterprisedna.com

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

eddd83 ,

 

You may try the measure below.

Measure =
COUNTROWS (
    FILTER (
        testData,
        DATEDIFF ( testData[Due Date], MAX ( 'Date'[Date] ), MONTH ) = 0
    )
)
eddd83's avatar
eddd83
Resolver I
7 years ago

The measure in the last post didn't work either.

 

 

I ended up using power query in Excel and the queries auto-run whenever the file opens. Then using various array formulas, I produced my desired result.

 

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    7 years ago

    I believe you can create a virtual relationship bewteen tables using the TREATAS function (never used it myself; so far have managed with inactive relationships and USERELATIONSHIP). Sorry I can't be of further help, but might be worth scouting the internet.

     

    Try here for example: TREATAS by enterprisedna.com