top of page

POWER BI QUERYOUS

DAX and M-code Repository

Power BI Queryous serves as a safe place for data geeks. A rich repository of Power BI knowledge, including DAX and M-code.


 So, sit back, relax, and read on.

95970959.jpg
Home: Welcome
Home: Blog Feed
Search
Sep 27, 20218 min read

ISO Calendar

fnDateTable - standard ISO 1086 Calendar - Copy as paste in blank query let Source = let fnDateTable = ( StartDate as date, EndDate as...

 
 
Sep 27, 20211 min read

Remaining Forecast / Allocation

Actual & Forecast = VAR _LatestDate = CALCULATE(MAX(Dates[LatestMTD]), REMOVEFILTERS()) VAR _Forecast = CALCULATE([Measure Forecast],...

 
 
Sep 27, 20211 min read

Standard YTD

DAX: Standard Calendar YTD YTD Total = // Get latest complete month VAR _YtD = MAX( Dates[LatestMTD] ) // Calculation VAR _Total =...

 
 
Sep 26, 20211 min read

Snapshot YTD

A variation of the standard YTD measure Snapshot YTD This measure is used for scenarios where you have non-standard snapshot calendar...

 
 
Home: Blog2

No product

Home: Featured Product
bottom of page