https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-a-relative-measure-in-a-card/m-p/3110691#M156739 <P>Hi all,</P><P>&nbsp;</P><P>I've set in my model a book to bill measure which I measure within a certain timeframe window and this is obtained by dividing two different moving averages.</P><P>&nbsp;</P><P>This is helpfull to see the trends but I would like to show in a card just the value of the book to bill related to the last week.<BR />I use something like BtB=calculate(Booktobill, Week_offstet=-1) but it doesn't show the correct value.</P><P>Im afraid that, selecting "Week_offstet=-1") this drive to a reduction of the timeframe of the analysis and return the wrong number for the book to bill.<BR />How can I solve this issue?</P><P>Thanks</P> Fri, 03 Mar 2023 15:20:21 GMT Anonymous 2023-03-03T15:20:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-a-relative-measure-in-a-card/m-p/3110691#M156739 <P>Hi all,</P><P>&nbsp;</P><P>I've set in my model a book to bill measure which I measure within a certain timeframe window and this is obtained by dividing two different moving averages.</P><P>&nbsp;</P><P>This is helpfull to see the trends but I would like to show in a card just the value of the book to bill related to the last week.<BR />I use something like BtB=calculate(Booktobill, Week_offstet=-1) but it doesn't show the correct value.</P><P>Im afraid that, selecting "Week_offstet=-1") this drive to a reduction of the timeframe of the analysis and return the wrong number for the book to bill.<BR />How can I solve this issue?</P><P>Thanks</P> Fri, 03 Mar 2023 15:20:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-a-relative-measure-in-a-card/m-p/3110691#M156739 Anonymous 2023-03-03T15:20:21Z