Convert SQL function to PowerBI Measure
I’m looking to convert this SQL function into a PowerBI Dax measure. I need the dax measure to read SELECTEDVALUE of ‘tblInventoryHistory'[LocNo], ‘tblInventoryHistory'[ItemNo] and tbl’Date'[Date]. any help would be appreciated. USE [Pos] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[DaysOnHand] ( @LocNo int, @ItemNo int, @AsOf datetime ) RETURNS int AS … Read more