Forum Discussion
Cumulative DISTINCTCOUNT with time intelligence
I am having trouble with DAX and need some help! Here is what I am trying to do: I want to report on DISTINCTCOUNT of TenantID cumulatively by Week, Month and Quarter. Below is what I have attemp...
lc_finance
Solution Sage
Solution SageHi my76 ,
Have you tried using TOTALMTD?
https://docs.microsoft.com/en-us/dax/totalmtd-function-dax
This should give you exactly what you are looking for.
If you still have issues, can you share a sample Power BI file (via OneDrive, Google Drive or similar)?
Regards
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com