Month: March 2020

  • Filter a measure with a slicer??

    Posted on 

     by 

    Mark Walter

     in 

    Filter a measure with a slicer??

    I gotta share something I saw from v-jiascu-msft on the community forum. I have an original measure that evaluates total sales over $50 as high, and under as low. I then write the below measure that references a disconnected table. Last step

    Continue reading

  • Custom DAX Calendar Table in Excel

    Posted on 

     by 

    Mark Walter

     in 

    Custom DAX Calendar Table in Excel

    Expandable Excel calendar table including US holidays and workdays. Time intelligence Calendar table in Excel used for custom time intelligence calculations in DAX. It includes text labels, US holidays, numeric calendar references, and unique sequence numbers for calculating custom time intelligence at

    Continue reading

Categories

Archives

Tags

Accounting analytics basic dax Calendar table Cigarettes were the death of me Context Transition in DAX cpa data data storytelling datastorytelling DAX dax 101 dax custom subtotals DAX Measure vs. Calculated Column excel Excel Calendar Table Excel or Power BI Excel to power bi Excel vs. Power BI filter vs. row context Fiscal Calendar Excel Honolulu Star-Bulletin Intro to dax Intro to Power BI learn dax Learn Power BI markwaltercpa Mark Walters matrix income statement matrix subtotals Microsoft Powerbi Power BI Power BI 101 Power BI Calendar Table Power BI Date Table Power BI Income Statement Power bi matrix PowerPlatform PowerQuery Start out in powerbi Start with Power BI Storytelling The Man Who Wrote His Own Obituary US Holidays in Excel