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

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